A condition matching 0.1% of rows is highly selective and favors an index; one matching 70% is not, and a sequential scan is usually cheaper.
Selectivity
The fraction of rows a condition keeps.
A condition matching 0.1% of rows is highly selective and favors an index; one matching 70% is not, and a sequential scan is usually cheaper.