selectivity

How small a fraction of rows a condition matches: a highly selective condition matches few rows.

In more detail

An index pays off when the condition is selective, such as one customer's orders. A condition that matches most rows, such as a status that is almost always paid, may be faster to answer with a scan, so an index on it may not be worth its cost.

Related terms

Taught in

References