ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

EXPERIENCE_ESTIMATE function [Miscellaneous]

Function 

This function is the same as the ESTIMATE function, except that it always looks in the frequency table.

Syntax 

EXPERIENCE_ESTIMATE (
column-name
[ , value [, relation-string ] ] )

Parameters 

column-name    The name of the column that is being investigated.

value    The value to which the column is compared.

relation-string     The comparison operator used for the comparison, enclosed in single quotes; the default is '='.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.

See also 

ESTIMATE function [Miscellaneous]

Example 

The following statement returns NULL.

SELECT DISTINCT EXPERIENCE_ESTIMATE( emp_id, 200, '>' )
FROM employee