Update table statistics on individual columns.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select a table that contains the column.
- Select Properties.
- Click Columns.
- Select the column for which to update statistics.
- (Optional) Click Use sampling, then enter the sampling
percentage.
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.
- (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.
- (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.
- Click Finish to apply the update statistics option selections.