HOW TO: Specify the Statistics Sampling Method used during Automated Statistics Maintenance

RockSolid will use the “Default” statistics sampling method when initiating the automated update statistics maintenance. However this can be overridden with a specific sampling method.


Manually Specifying the Update Statistics Sampling Method
In order to manually specify the statistics sampling method follow the following process.

  • Navigate to the relevant level in your database policy hierarchy.
  • Choose the “Settings” tab to choose view the policy and then choose the “Performance” sub-tab.
  • In the Database Statistics section set the Statistics Update Method to Enabled.
  • Set the “Statistics Update Method” drop down to either “Full Scan” or “Resample” to override the default setting.


Automatically Specifying the Update Statistics Sampling Method
To have RockSolid automatically determine the most efficient statistics update method at run-time during the rebuild process, instead set the “Statistics Update Method” drop down to “Auto Select”.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.