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