SQL statement

hi,

if i do the following statement, the result is instant.

select a.UIN, a.Name, a.Street_Code, a.Block, a.Storey_No, a.Main_Hse, a.Sub_Hse, a.Sex_Code, a.DOB, a.Race_Code, a.Country_of_Birth_Code, a.Bkgrd_Lang_Stream_Code, a.Edn_Code, a.Religion_Code from tb_EASY_RMF a where citizenship_code = '0' and to_number(rpad(dob,8,'0')) <= to_number(to_char(to_date('31/05/1978','DD/MM/YYYY'),'YYYYMMDD')) and Date_New_IC_Issued <= to_date('31/05/1999','DD/MM/YYYY');

but is i add a order by at the end, it seems like hanging there, why? pls help cos, it's urgent. thanks..

select a.UIN, a.Name, a.Street_Code, a.Block, a.Storey_No, a.Main_Hse, a.Sub_Hse, a.Sex_Code, a.DOB, a.Race_Code, a.Country_of_Birth_Code, a.Bkgrd_Lang_Stream_Code, a.Edn_Code, a.Religion_Code from tb_EASY_RMF a where citizenship_code = '0' and to_number(rpad(dob,8,'0')) <= to_number(to_char(to_date('31/05/1978','DD/MM/YYYY'),'YYYYMMDD')) and Date_New_IC_Issued <= to_date('31/05/1999','DD/MM/YYYY') order by Street_Code, Block, Storey_No, Main_hse, Sub_hse;

--

evelyn.

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Mon May 10 1999 - 21:54:16 CDT