How to check if an index created is being used by the application - Oracle 8.1.6

[siva2102]

Would appreciate if someone could help me to identify indexes which are being used by applications. My development team has created many many indexes and I am sure some of the indexes are not being used resulting in performance issues.

Thanks

[Vipassana]

Check the view v$object_usage. An Yes or a NO will indicate whether the index is being used.

However if u want to know if a specific query of the application is using an index, you can EXPLAIN PLAN and see the output.

[Dilippatel]

Vipassana, the v$object_usage is included in the 9i, so we may have to rely on the Explain plan.

You can search the queries for the related table from v$sql and then check the queries for the explain plan.

[Vipassana]

Originally posted by Dilippatel
Vipassana, the v$object_usage is included in the 9i, so we may have to rely on the Explain plan.

You can search the queries for the related table from v$sql and then check the queries for the explain plan.

oh ur r right sir. i missed to observe he works on 8i.