Contents Index sa_get_dtt system procedure sa_get_request_profile system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_get_histogram system procedure


Function 

Retrieves the histogram for a column.

Syntax 

sa_get_histogram ( columntable [, owner ] )

Permissions 

SELECT permission required.

Side effects 

None.

See also 

The Histogram utility

ESTIMATE function [Miscellaneous]

ESTIMATE_SOURCE function [Miscellaneous]

Description 

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.


Contents Index sa_get_dtt system procedure sa_get_request_profile system procedure