|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|
I am querying a table with 5 millions records and 5 fields using the
following SQL code:
create table test as
from temp.lab l
where =lab_id in ('8888-8','9999-1')
order by id, sample_dt;
It takes very long time to run (6 minutes). Is a way to make it run faster?
Thanks in advance.
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.