Identify unused indexes (indexes that consume space and INSERT/UPDATE CPU but are never chosen by the optimizer) - Identify missing indexes (tablespace scans on large tables that could benefit from an index) - Review index key compression opportunities