Index usage in Order by clause

From: <jaysingh1_at_optonline.net>
Date: Tue, 15 Jun 2004 09:18:05 -0400
Message-id: <eceb8becc9ef.ecc9efeceb8b@optonline.net>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jun 15 2004 - 08:15:08 CDT