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
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
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.
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.Quote:
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.