LOAD STATISTICS statement

Intended for internal use, this statement is used by the dbunload utility to unload column statistics from the old database into the ISYSCOLSTAT system table.

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.

Privileges

You must have the MANAGE ANY STATISTICS system privilege.

Side effects

None.

Standards

ANSI/ISO SQL Standard
Not in the standard.