I'm doing an ALTER INDEX REBUILD statement using the clause STATISTICS_NORECOMPUTE to OFF.
If I rebuild the indexes I have to update the statistics using UPDATE STATISTICS command for that particular table or the ALTER INDEX REBUILD statement take care updating the statistics for me?
ALTER INDEX ... REBUILD will give you fresh statistics as part of the index rebuild. But what you did was to turn off auto-update of statistics for that particular index.Tibor Karaszi
I read that the clause STATISTICS_NORECOMPUTE in the ALTER INDEX by default is set to OFF.
I was just trying to find out if by leaving it OFF the statement calculates the statistics by it self or if it doesnt if I have to execute an UPDATE STATISTICS statement to get the statistics recalculated after the ALTER INDEX have been executed.
If you leave this at the default, then the statistics will be auto-updated according tot he database setting for auto-update of statistics. But, again, the setting do no affect whether the index statistics is updated by the index rebuild in question - that is a natural and integral part of rebuilding an index.Tibor Karaszi
If I leave the default value in the alter index and the auto-update statistics setting in the database is not set, the statistics for the index will not be calculated with the alter index statement.
