Read more: http://www.blogsmonetize.com/2010/10/how-to-use-syntax-highlighter-3083-in.html#ixzz1DHzvEgBA

Monday, May 16, 2011

Does rebuild/re-organize index update the statistics?

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: