Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

LEAVE statement Next Page


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.


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 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.


Must have DBA authority.

Side effects


See also
Standards and compatibility