Update table statistics for partitions.
- 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 partition.
- Select Properties.
- Click Partitions .
- Select the partition for which to update statistics.
- Select the type of statistics update.
- (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.
- Click Finish to apply the update statistics option selections.