Cardinality statistics are computed by the system and stored
in the system tables. For information on when these statistics get created
or updated, see .
can use cardinality statistics if:
- 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