Contents Index LEAVE statement LOAD TABLE statement

ASA SQL Reference
  SQL Statements

LOAD STATISTICS statement


Description 

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.

Syntax 

LOAD STATISTICS [ [ owner.]table-name.]column-name
 format-iddensitymax-stepsactual-stepsstep-valuesfrequencies

Parameters 

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.

Permissions 

Must have DBA authority.

Side effects 

None.

See also 

SYSCOLSTAT system table

Unloading a database using the dbunload command-line utility

Standards and compatibility 

Contents Index LEAVE statement LOAD TABLE statement