Re: ORDER BY doesn't use index
An index on (status,req_id) would be the best
For the subquery, the inner query is checked for every row in the outer query, that is what unique_subquery means, but only need to check 1 row in the inner query and can use the primay key to find the row to check. The inner query needs to be executed 90 times, since you have limit 0,90
Subject
Views
Written By
Posted
12227
September 13, 2006 12:32AM
5387
September 13, 2006 02:00AM
Re: ORDER BY doesn't use index
3909
September 13, 2006 02:36AM
3541
September 27, 2006 03:39AM
3420
September 27, 2006 05:02AM
3329
September 30, 2006 05:53PM
3320
October 03, 2006 02:38AM
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.