Selectivity is how well a column filters rows (how many rows match a predicate). A highly selective index (few matches) is more useful, because the DB can avoid scanning many rows. Low-selectivity columns (like boolean flags) often don’t benefit much from a standalone index.