This is a very good question. I guess it can be a good question in interviews too.
Coming to the answer, am answering the question as two parts:
There are two types of statistics:Index stats(stats created on index) and column stats(stats created on individaul column)
1.Does rebuild index update the statistics?
Ans: Rebuild index will update statistics for the index, but not for the statistics of the columns.
2.Does re-organize index update the statistics?
Ans: Re-organize does not deal with statistics. Hence no update statistics.
Please refer the importance of stats here.
No comments:
Post a Comment