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
I agree with B. An index rebuild does update statistics for that index, but a reorganize does not. We don’t know which of the operations took place so I vote for B.
http://www.benjaminnevarez.com/2010/07/rebuilding-indexes-vs-updating-statistics/