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