ASA SQL Reference
SQL Statements
This statement loads statistics into the system table SYSCOLSTAT. It is used by the dbunload utility to unload column statistics from the old database. It should not be used manually.
LOAD STATISTICS [ [ owner.]table-name.]column-name
format-id, density, max-steps, actual-steps, step-values, frequencies
format_id Internal field used to determine the format of the rest of the row in the SYSCOLSTAT system table.
density An estimate of the weighted average selectivity of a single value for the column, not counting the selectivity of large single value selectivities stored in the row.
max_steps The maximum number of steps allowed in the histogram.
actual_steps The number of steps actually used at this time.
step_values Boundary values of the histogram steps.
frequencies Selectivities of histogram steps.
Must have DBA authority.
None.
Unloading a database using the dbunload command-line utility
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not applicable.