Help using Base SAS procedures

proc sql oracle join - reduce run time

Reply
Frequent Contributor
Posts: 87

proc sql oracle join - reduce run time


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;

Super Contributor
Posts: 578

Re: proc sql oracle join - reduce run time

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?

Super User
Posts: 5,437

Re: proc sql oracle join - reduce run time

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

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 206 views
  • 0 likes
  • 3 in conversation