tables with high read counts but only a primary key index. 2. **Redundant indexes** — indexes whose leading columns are a prefix of another index on the same table. 3. **Unused indexes** — indexes that have not been used in any access path since the last statistics reset.