STAT_GET_CARDINALITY

Get cardinality and selectivity for an expression. Example expressions for an integer column (other types work as well, but – note that there’s no way to escape brackets or commas in this trivial implementation): –‘123’ = 123 –’[123’ >= 123 –‘(123’ > 123 –‘123]’ <= 123 –’[10,20)’ >= 10 and < 20

Syntax

SELECT * FROM TABLE(
SYS_BOOT.MGMT.STAT_GET_CARDINALITY(
CATALOG_NAME,SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,EXPRESSION)
);