Toad World® Forums

Unselective indexes and skewed data distribution


The selectivity of an index is defined as the fraction of rows in a table having the same value for the indexed key. A highly selective index has few rows for each index entry and an unselective index has many rows for each index entry.

This is a companion discussion topic for the original entry at