Date:         Fri, 27 Aug 2010 14:37:20 -0400
Reply-To:     Bin Zhu <bxz01@HEALTH.STATE.NY.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bin Zhu <bxz01@HEALTH.STATE.NY.US>
Subject:      SQL performance
Content-Type: text/plain; charset=US-ASCII

Hi,

I am querying a table with 5 millions records  and 5 fields using the
following SQL code:
proc sql;
create table test as
select l.id,l.sample_dt
from temp.lab   l
 where =lab_id in ('8888-8','9999-1')
order by id, sample_dt;
quit;

It takes very long time to run (6 minutes). Is a way to make it run faster?
Thanks in advance.


Frank
IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation.