Hi All, I am facing performance issue when I am using Method 1. Now, I have to fix the performance issue by re-writing the query. Method 1. proc sql; connect to ORACLE ( DBEXT=XXXX BUFF=XXXXX PATH=XXXXX DOMAIN="XXXX" ); execute ( MERGE INTO Lib1.Target USING Lib1.Source ON ( Source.A_KEY = Target.A_key AND Source.P_KEY = Target.P_KEY AND Source.R_KEY = Target.R_KEY ) WHEN MATCHED THEN UPDATE set Target.col1= Source.col1, Target.col2= Source.col2, Target.col3= Source.col3, WHEN NOT MATCHED THEN INSERT ( Target.A_KEY, Target.P_KEY, Target.R_KEY, ) values ( Source.A_KEY, Source.P_KEY, Source.R_KEY, ) ) by ORACLE; disconnect from ORACLE; quit; ROCEDURE SQL used (Total process time): real time 30:45.15 I Need to fix the performance. Can anyone please suggest on this. Regards Rama Goteti.
... View more