Date:         Fri, 7 Apr 2000 21:29:58 GMT
Reply-To:     Lou Pogoda <lpogoda@HOME.NOSPAM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lou Pogoda <lpogoda@HOME.NOSPAM.COM>
Organization: @Home Network
Subject:      Re: Please help: Oracle-Index is not used to match table and
              dataset

Sebastian -

You're a little less than clear here, some example code would help us figure
out what's going on.

I haven't tried this with SAS 8, so these comments apply to version 6.

It sounds like you're using something like a data step to run a merge on an
ORACLE table and a SAS data set.  If that's the case, what's probably
happening is that the *entire* ORACLE table is being exported to SAS, which
then does the merge.  And of course, when the ORACLE table is exported, it's
the data only, not the index.

You're best bet is most likely to create an ORACLE table and load the 40,000
SAS observations to it, then use pass-thru code to do the match in ORACLE.
Once you have the result, it can be exported back to SAS.  Check out PROC
DBLOAD for loading your SAS data to ORACLE, and getting ORACLE data back to
SAS.


Sebastian Knecht wrote in message <8ckeog$6jt78$1@fu-berlin.de>...
>Hello,
>
>i have an oracle-database containing several tables with indices, each
table
>has about 2.000.000 entries. When I try to perform a match on that table
>with a second dataset (40.000 entries) to produce a third dataset, which
>contains all differences, the oracle-indices seem not to be used, so that
>the entire action lasts hours. Does anybody know this problem (Sas V8) ...?
>
>Awaiting your answers...
>Thank you
>Sebastian
>
>