Skip to content

Database

Index Selectivity Estimator

Total rows and distinct values in a column, turned into a selectivity score - and whether an index there will actually help or get ignored.

0.0004% selectivity - Poor

Low selectivity - the query planner may skip this index entirely and prefer a full table scan, since reading the index plus the table can cost more than just scanning.