Large SQL query performance check

You have a very large query say of 2000 lines. How would you check if the indexes are being used or not. Would you read all the lines of explain plan in plan table to get it? If yes, will it be feasible? Do you have any other method of checking this?

Questions by VNeha

Showing Answers 1 - 2 of 2 Answers


  • May 7th, 2012

Check and resolve join with the largest cost

  Was this answer useful?  Yes

raghuvir Khanna

  • May 10th, 2012

We can moniter the use of indexed with the help of view V$object_usage simple we need to use
Alter index monitoring usage;
select tablename,indexname ,used from V$object_usage ;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions