USTLOW_SAMPLE configuration parameter
Use the USTLOW_SAMPLE configuration parameter to enable the generation of index statistics based on sampling when you run UPDATE STATISTICS statements in LOW mode.
For an index with more than 100 K leaf pages, the gathering of statistics using sampling can increase the speed of the UPDATE STATISTICS operation.
- onconfig.std value
- USTLOW_SAMPLE 1
- values
0
= disable sampling1
= enable sampling- takes effect
- After you edit your onconfig file and restart the database server.