This content has been marked as final. Show 2 replies
Use SQL*Plus and run an explain plan on the statement and see where it is using full table scans and not using indexes where you think it should be using indexes.
It is very hard to do this sort of thing without the tables structures, amounts of data etc.
Search on running explain plans.