LOAD STATISTICS statement

For internal use only. This statement loads statistics into the ISYSCOLSTAT system table. It is used by the dbunload utility to unload column statistics from the old database. It should not be used manually.

Syntax
LOAD STATISTICS [ [ owner.]table-name.]column-name
 format-id, density, max-steps, actual-steps, step-values, frequencies
Parameters
  • format-id   Internal field used to determine the format of the rest of the row in the ISYSCOLSTAT 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.

Permissions

Must have DBA authority.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.