# 📋 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).

Connection:
Analysing index usage and column overlap…
Querying V$OBJECT_USAGE + DBA_IND_COLUMNS
📋
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;
⚠️ Dropping an index is irreversible. Verify each suggestion with an explain-plan before dropping. Unused indexes may still protect FK constraints.
Unused Indexes (monitoring=YES, used=NO)
Prefix-Redundant Indexes