PPT Slide
How? Follow the rules in the Performance Guide to get the best balance between runtime and statistics quality.
- MEDIUM on the whole table to update uninteresting columns.
- HIGH on the first column of each index (but on any one column only once).
- If composite indexes start with the same column(s) HIGH on the first column that is different in each index.
- Low on each complete index column list to update the sysindexes columns.
OR: Just get my dostats utility (or another) that implements this.