Re: Oracle - Out of process memory

Johnny Yeung wrote:

>The SQL statement is:
>select distinct street_h, STREET_SEQ from building group by bldg_h,
>estate_h, street_h, district_e, area_e, STREET_SEQ having (1=1) and
>district_e = 'CHAI WAN' and area_e = 'HKG' ORDER BY STREET_SEQ;
>
>
Hello Johny,

this statement might be improved a lot from the following: select distinct

         street_h
,        STREET_SEQ
from     building  
where    district_e = 'CHAI WAN'
and      area_e     = 'HKG' 
group by bldg_h
,        estate_h
,        street_h
,        district_e
,        area_e
,        STREET_SEQ

Herman de Boer
sr consultant
IT Consultancy Group bv Received on Thu Aug 15 2002 - 09:58:15 CEST