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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » Views » System views

 

SYSCOLSTAT system view

The SYSCOLSTAT system view contains the column statistics, including histograms, that are used by the optimizer. The contents of this view are best retrieved using the sa_get_histogram stored procedure or the Histogram utility. The underlying system table for this view is ISYSCOLSTAT.

Column name Data type Description
table_id UNSIGNED INT A number that uniquely identifies the table or materialized view to which the column belongs.
column_id UNSIGNED INT A number that, together with table_id, uniquely identifies the column.
format_id SMALLINT For system use only.
update_time TIMESTAMP The local time of the last update of the column statistics.
density FLOAT An estimate of the average selectivity of a single value for the column, not counting the large single value selectivities stored in the row.
max_steps SMALLINT For system use only.
actual_steps SMALLINT For system use only.
step_values LONG BINARY For system use only.
frequencies LONG BINARY For system use only.
update_time_utc TIMESTAMP WITH TIME ZONE The UTC time of the last update of the column statistics.
Note

For databases created using SQL Anywhere 16 or later, the underlying system table for this view is always encrypted to protect the data from unauthorized access.

 Constraints on underlying system table
 See also