Index usage in Order by clause
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Jun 2004 09:18:05 -0400
Dear All,
I have a question about index column in order by clause. The below query is
taking 3 min to get the result but the sametime if I comment out ORDER BY
clause it is taking only 3 secs.
Is it possible to improve the performance by creating an index on
table2.lastupdatedate column
SELECT * FROM (
SELECT /*+ FIRST_ROWS */
p.processed_by,
p.last_name,
p.first_name,
p.company_name,
p.userid
FROM table1 p,table2 e
where p.business_country_id='GB'
and p.uk=e.pk
and e.userstatusid in ('5')
order by e.lastupdatedate desc
)
WHERE ROWNUM <=10
/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Index usage in Order by clause
