Selectivity from cardinality statistics

Selectivity from cardinality statistics Cardinality statistics are computed by the system and stored in the system tables. Selectivityfrom cardinality statistics

For information on when these statistics get created or updated, see .

can use cardinality statistics if all of the following are true:

The statistics exist.
The relevant columns in the WHERE column are leading columns in an index.
The columns are compared to values using only the = operator.
Statistics are not turned off in the system or query.