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>
Organization: http://groups.google.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:

data _dataset_;
  set _oracletable_( keep = _fields_I'm_interested_in_ );
  where _conditions_;
  run;

Thanks for any help you can offer.

Shaun