Getting list of Query which are all not using Index
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
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.