topic proc sql oracle join - reduce run time in SAS Procedures

proc sql oracle join - reduce run time

helloSAS — Tue, 03 Sep 2013 18:00:36 GMT

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

a.abc = b.extnl

where b.srcs >= sysdate-27

);

disconnect from oracle;

quit;

Re: proc sql oracle join - reduce run time

DBailey — Tue, 03 Sep 2013 19:03:13 GMT

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?

Re: proc sql oracle join - reduce run time

LinusH — Tue, 03 Sep 2013 19:23:46 GMT

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