Date: Tue, 11 Nov 2003 09:07:58 -0800
Reply-To: Shaun <Shaun.Carlson@WELLCARE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Shaun <Shaun.Carlson@WELLCARE.COM>
Subject: DATA step utilizing an oracle index
Content-Type: text/plain; charset=ISO-8859-1
I am fairly new SAS user, and I am querying a rather large database
(tens of millions of records) to pull based on a few criteria. The
query took much longer than I expected from a SAS process (15-20
minutes), so I sent my query to the DBA so he could index the table. I
just got a reply from him saying the index has been created and
analyzed, so I re-ran the process. It is still taking just as long.
Do I have to give SAS a special command so that it knows there is an
index it can make use of? My data step is very simple:
set _oracletable_( keep = _fields_I'm_interested_in_ );
Thanks for any help you can offer.