You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this?()
- Aenable index monitoring and query the DBA_OBJECTS view
- Benable index monitoring and query the DBA_INDEXES view
- Cenable index monitoring and query the V$OBJECT_USAGE view
- Denable index monitoring and view the DBA_INDEXTYPE_COMMENTS view