ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

INDEX_ESTIMATE function [Miscellaneous]

Function 

This function is the same as the ESTIMATE function, except that it always looks only in an index.

Syntax 

INDEX_ESTIMATE( column-name, number [ , relation-string ] )

Parameters 

column-name     The name of the column that is used in the estimate.

number     If number is specified, the function returns as a REAL the percentage estimate that the query optimizer uses.

relation-string     The relation-string must be a comparison operator 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]

ESTIMATE_SOURCE function [Miscellaneous]

Example 

The following statement returns the value 81.304607.

SELECT FIRST ESTIMATE( emp_id, 200, '>' )
FROM employee