Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sql Query - Help

Sql Query - Help

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 1 Jun 2005 10:29:50 -0700 (PDT)
Message-ID: <20050601172950.80024.qmail@web51309.mail.yahoo.com>


I had query  

select * from

(select inner.*, rownum rn from

(select ID from emp_dtl where 1 = 1 AND Group='WHO' and Cust_acct='GE' and Update_tag = 'F' and Category_code=1 order by Acct_num, seq_number )inner

 where rownum < 100)

where rn >= 50  

The Inner Portion run in few second , while the reamining query takes ages like 40-45minutes. Any idea as what I am missing or any optimization.  

TIA Sanjay                 



Discover Yahoo!
 Get on-the-go sports scores, stock quotes, news & more. Check it out!
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 01 2005 - 13:34:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US