Update table statistics for partitions.
- Select , 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 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.
- (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.