Date:         Fri, 11 Aug 2006 13:44:13 EDT
Reply-To:     EvilPettingZoo97@AOL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Borowiak <EvilPettingZoo97@AOL.COM>
Subject:      Re: Joining Large Datasets
Content-Type: text/plain; charset="US-ASCII"

The DataSavant wrote ..


With respect to:

<<<<

>[1] I'm not going to ask why you don't have indices.  I'm going to ask
>something else annoying.  Is it possible that the Oracle tables *do* have
>indices?  I ask because indices are very important in Oracle, and it seems
>more likely that you have not *found* the indices, or that your schema
>does not allow you to see them.

You should be able to find them yourself, but you do have to use
pass-through code:

proc sql;
   connect to oracle as test(user=" " password=" " path=" " );
   CREATE TABLE indexes as
      select * from connection to test
        ( select * from ALL_ind_COLUMNS )
      order by table_name,column_name;
quit;

Regards,
Gregg Snell

With respect to:

>[1] I'm not going to ask why you don't have indices.  I'm going to ask
>something else annoying.  Is it possible that the Oracle tables *do* have
>indices?  I ask because indices are very important in Oracle, and it seems
>more likely that you have not *found* the indices, or that your schema
>does not allow you to see them.

You should be able to find them yourself, but you do have to use
pass-through code:

proc sql;
   connect to oracle as test(user=" " password=" " path=" " );
   CREATE TABLE indexes as
      select * from connection to test
        ( select * from ALL_ind_COLUMNS )
      order by table_name,column_name;
quit;

Regards,
Gregg Snell    >>>>    I believe you can get access the Oracle metadata
without the Pass-Through facility.I wrote about this once  (... not the best UG
paper I have written, but hey it was my first) ...
http://www.nesug.org/html/Proceedings/nesug04/po/po12.pdf Regards, Ken