their leading columns were a subset of another index on the same table. For example, the POLICY table had indexes on both `(AGENT_ID)` and `(AGENT_ID, EFFECTIVE_DATE)`. The single-column index served no purpose that the composite index could not. - **8 indexes were on low-cardinality columns** (STAT