📋 Index Usage Advisor Read-only

Detect unused monitored indexes (V$OBJECT_USAGE USED=NO) and prefix-redundant indexes (column list is a strict prefix of a longer sibling on the same table).

📋
Select a connection and click "Fetch"
Checks V$OBJECT_USAGE for unused indexes and DBA_IND_COLUMNS for redundant columns.
Enable index monitoring with: ALTER INDEX <name> MONITORING USAGE;