Statistics-based versus hard-wired selectivity
determines the selectivity for a WHERE clause in one of two ways.
Selectivity from cardinality statistics
Selectivity from hard-wired assumptions
Selectivity and cardinality statistics
Determinations of rows scanned from disk for a table scan
Estimations of rows scanned from disk for an index scan
What are cardinality statistics?
Working with cardinality statistics