LOAD STATISTICS statement

For internal use only. 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

Side effects

Standards and compatibility

Discuss this page in DocCommentXchange.

LOAD STATISTICS statement

Syntax

Parameters

Permissions

Side effects

See also

Standards and compatibility