The Adaptive Server query optimizer uses statistics to optimize queries.
Run the update statistics commands on tables (data sets) to update information about the distribution of key values in specified indexes or columns, for all columns in an index, or for all columns in a table. The commands revise histograms and density values for column-level statistics.
