For example, assume that you create a partitioned index, and then you set the STATISTICS_NORECOMPUTEproperty toON. Then, you rebuild the index without setting the STATISTICS_NORECOMPUTE property to ON or OFF. In this situation, the NORECOMPUTE property is unexpectedly set to 0. Therefore, the STATISTICS_NORECOMPUTE property is set to OFF.
- To check the value of the NORECOMPUTE property, query the Sys.stats system table.
- This issue occurs only when the table is not empty.
Cumulative update information
Cumulative Update 3 for SQL Server 2012 SP1The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2012 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2814780 - Last Review: Mar 18, 2013 - Revision: 1