The update statistics command updates column-related statistics,
such as histograms and densities.
- In the Administration Console view, select .
- Select the table on which to run update statistics.
- Select Update Statistics.
You see the Introduction screen of the Update
Statistics wizard for the table you selected.
- Click Next.
- On the Command Type screen, select the update
statistics command to run. Click Next.
- On the Data Partitions screen, select Specify a data
partition, if applicable, and indicate any data partitions.
update statistics runs on all partitions if you do not specify
one. Click Next.
- On the Columns screen, indicate if you want:
- To run update statistics on specific columns.
- Histograms on all columns (the default).
- To updates statistics in ordered column grouping. Adaptive Servers earlier than 15.7 ESD #2
support only ordered grouping statistics; the histograms option is
unavailable.
- Click Next.
- On the Indexes screen (not available if you selected update all statistics
on the Command Type tab, or specified any columns on the Columns tab), indicate any
indexes on which to run update statistics. If you do not select
any indexes, update statistics updates all indexes.
- Click Next.
- On the Index Partitions screen (visible when you select an index on the Indexes screen),
indicate the index partition to update.
- Click Next.
- On the Hashing screen, select:
- The type of hashing:
- Partial hashing – for columns that have 65536 or fewer unique
values.
- With hashing – for columns that have greater than 65536 unique
values.
- No hashing.
- A value for max resource granularity (which indicates the maximum percentage
of the system’s resources a query can use), if applicable.
- Click Next.
- On the Histogram Tuning screen, set the histogram tuning factor.
The size of the histogram is established by multiplying the number of steps with the
value for histogram tuning factor.
- Click Next.
- On the Sampling screen, specify whether to set sampling, and to what percentage.
- Click Next.
- On the Step Number screen, indicate if want to set the number of histogram steps, and how
many.
- Click Next.
- On the Consumers screen, set the number of consumer processes to be used in parallel
processing, and the number. The controls are enabled if the value for max
parallel degree is 3 or greater.
- Click Next.
- On the DataChange Threshold screen, indicate whether to run update
statistics when it reaches a data change threshold, and if so, the value
of the threshold.
- Click Next.
- On the Summary screen, verify your selections.
- Click Finish.