Unable to declaratively disable "auto-statistics" update on tables - by Daniel Adeniji

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774642 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/18/2012 8:01:02 AM
Access Restriction Public


Unable to declaratively disable "auto-statistics" update on tables

At database level,
   we can disable "Auto Update Statistics" 

   ALTER DATABASE <database>

   and determine current status

      select databasepropertyex('sam', "IsAutoUpdateStatistics') 

At the Table level:

    we can disable stat

       EXEC sp_autostats <object-name>, 'OFF';

    and determine stats

       EXEC sp_autostats <object-name>

But, it appears that sp_autostats' true granularity is at Index\Statistics Level.

When setting it for a table, it seems to apply to all current\existing Indexes\Statistics.

When Querying it, it returns information for all existing Indexes\Statistics.

In some use cases, one might want to declaratively specify that Statistics should never be automatically re-calibrated for specific table(s).

Also, one should be able to query for same, that is determine at a table object, and not Database nor Statistics, whether Statistics are being auto maintained.

Not being able to determine if it is a table level, one just as to keep issuing sp_autostats and pass in the table's name.
Sign in to post a comment.
Posted by Microsoft on 1/16/2013 at 2:36 PM
Thanks for the feedback, if there is enough interest within the community we can consider this for future releases.