Index seek operation -- Nonclustered index

You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query named Query1 that uses the nonclustered index. Users report that Query1 takes a long time to report results. You run Query1 and review the following statistics for an index seek operation:

You need to resolve the performance issue. Solution1: You drop the nonclustered index.

Solution2: You defragment both indexes.

Solution3: You update statistics for the nonclustered index.

Solution4: You rebuild the clustered index.

---

Answer Given: Solution3 We see Actual Number of Row is 3571454, while Estimated Number of Rows is 0. This indicates that the statistics are old, and need to be updated.

For Solution 4:

The query uses the nonclustered index, so improving the clustered index will not help. We should update statistics for the nonclustered index.