Index usage in order by clause

From: <jaysingh1_at_optonline.net>
Date: Tue, 15 Jun 2004 08:54:54 -0400
Message-id: <ec1a7eec4006.ec4006ec1a7e@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 - 07:52:31 CDT