proc sql oracle join - reduce run time

[helloSAS]

Hi,

I'm using below code to reduce run time for this query. What do i do run in less time? or if i have to use Index how do i do it?

proc sql;

  connect to oracle;

  create table part as

  select * from connection to oracle

  (

  select

   a.abc,

   b.srcs,

   b.prtnr,

   b.clnt,

   b.extnl

  from

        prp a left join

    PRTNR b

  on

        a.abc = b.extnl

   where b.srcs >= sysdate-27

  );

disconnect from oracle;

quit;

[DBailey]

When you have criteria applied to the right side of a left join it essentially becomes an inner join.  What indexes are available on the oracle tables?

[LinusH]

This is a SAS forum. You will gain better feedback if put this question on an Oracle forum instead.