Working with cardinality statistics

Cardinality Statistics are gathered on the keys of an index when the index is created.

Related concepts
Determinations of rows scanned from disk for a table scan
Estimations of rows scanned from disk for an index scan
Statistics-based versus hard-wired selectivity
What are cardinality statistics?