USE_COMPARABLE_ESTIMATES (SELECT OPTION)

USE_COMPARABLE_ESTIMATES option is used for getting partition points for varchar columns successfully. The distribution in the SelectableEstimate will therefore resolve to StringIndex corresponding to varchar column.

Operator

SELECT

Syntax

use_comparable_estimates

Example

SELECT {OPTION USE_COMPARABLE_ESTIMATES} TAN(column1) FROM table1