Getting list of Query which are all not using Index
Posted by: Ramprabhu M
Date: April 13, 2016 02:07AM

Hi All,

Please help us on how to capture the query which are all performing full table scan and the query which are all not using index.

We have tried enabling slow query log, as a result we found none of the query captured in slow query log,but our query performance seems to be still low. At present, We have decided to find the query which do not uses index. So please help us in capturing those queries without any impact

Thanks
Ramprabhu

Options: ReplyQuote


Subject
Written By
Posted
Getting list of Query which are all not using Index
April 13, 2016 02:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.