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?

Showing Answers 1 - 6 of 6 Answers

Sam

May 7th, 2012

Check and resolve join with the largest cost

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 ;