1 of the query's of a colleague of mine has been slowing down recently.
He looked to the execution plans and the index fragmentation and found a fragmented index, which he then rebuild.
No resolve, fragmentation was gone but the performance remained slow.
He then did an update statistics which resolved it.
Now I'm confused,and the the things I found searching about it are contradicting.
If you rebuild an index the statistics get updated,is this the case or not.
I've requested more info on the table and query.
But anyone who can tell me why you would need an update statistics after an index rebuild please do.
Is there a way to check all statistics of a table