Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 774642
Opened: 12/18/2012 8:01:02 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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

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

ALTER DATABASE <database>
         SET AUTO_UPDATE_STATISTICS ON;

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.

Details
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.
Sign in to post a workaround.