Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

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.

Solution: You defragment both indexes.

Does the solution meet the goal?

A. Yes

B. No

Explanation:

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.