---------- > From: Bernard Tremblay <bernard@CAPITALE.QC.CA> > To: SAS-L@UGA.CC.UGA.EDU > Subject: Re: SASTIP: optimising SQL > Date: 9. oktober 1997 06:32 > > Dear Richard, > > Your suggestion is not an "optimisation" for the following > reason: > > SAS will use temporary tables for each of the inner select clause; > So you will have a copy of those 2 table subset of your original > tables... and thus use more temporary disk space! The dataset > options are definitly the best that can be done. > > Regards, > Bernard Tremblay > \\\|/// > \\ - - // > ( @ @ ) > +------oOOo-(_)-oOOo----------+---------------------------------+ > | Bernard Tremblay | | > | La Capitale | Tel: (418) 646-2401 | > | | Fax: (418) 646-5960 | > | | Int: bernard@capitale.qc.ca | > +-----------------------------+---------------------------------+ > | Imaginasys enr | Res: (418) 878-4447 | > | | Int: bertrem@quebectel.com | > +---------------Oooo----------+---------------------------------+ > oooO ( ) > ( ) ) / > \ ( (_/ > \_) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~ > >>> > >>>I'm no SAS SQL timing guru, but how would the following fit in the rank > >>>of 'optimization' ? > >>> > >>>create table newtable as > >>> select a.*,b.p_date from > >>> (select * from million9 where outcomec=0) as a, > >>> (select p_date, case_id from million4 where p_date ne .) as b > >>> where a.case_id = b.case_id ;