ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Retrieves the histogram for a column.
sa_get_histogram ( column, table [, owner ] )
SELECT permission required.
None.
ESTIMATE function [Miscellaneous]
ESTIMATE_SOURCE function [Miscellaneous]
This procedure retrieves data from the system table SYSCOLSTAT. It is intended for internal diagnostic purposes. It is recommended that you view histograms using the Histogram utility.
To determine the selectivity of a predicate over a string column, you should use the ESTIMATE or ESTIMATE_SOURCE functions. For string columns, both sa_get_histogram and the Histogram utility retrieve nothing from SYSCOLSTAT. Attempting to retrieve string data generates an error.