EXPERIENCE_ESTIMATE function [Miscellaneous]

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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

EXPERIENCE_ESTIMATE function [Miscellaneous]

Returns selectivity estimates as a percentage calculated by the query optimizer, based on specified parameters.

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. Possible values for this parameter are: '=' , '>' , '<' , '>=' , '<=' , '<>' , '!=' , '!<' , and '!>'. The default is '='.

Returns

Remarks

See also

Standards and compatibility

Example

Discuss this page in DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0