Updating Index Statistics

Update table statistics for individual indexes.

1. Select ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
2. Select a table that contains the index.
3. Select Properties.
4. Click Indexes .
5. Select the index for which to update statistics.
6. (Optional) Click Use sampling, then enter the sampling percent.
   The percentage to use when sampling depends on your needs. Test various percentages until you receive a result that reflects the most accurate information on a particular data set.
7. (Optional) Click Use step number, then enter the step numbers.
   Increasing the number of steps beyond what is needed for good query optimization can affect performance, largely due to the amount of space that is required to store and use the statistics.
8. (Optional) In the Automatic Update window, click on Update statistics only when datachange threshold is reached, and enter a threshold value.
   The datachange threshold determines when the amount of change in a table or partition has reached the predefined threshold.
9. Click Finish to apply the update statistics option selections.