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

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements


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.

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.


You must have the MANAGE ANY STATISTICS system privilege.

Side effects


  • ANSI/ISO SQL Standard

    Not in the standard.