Hi , Please help me onthis. below is proc sql query which needs to be optimized as it runs for 10 hours . there are  two large tables , largetb1(with arrround 30 million records) & largetb2(2 mililon records) . To optimize below one , i have to earse sort action (highlighted one in below log). how do i erase sort (sqxsort) action in below query ? -------------------------------------------------------------------------- 818   proc sql noprint _method ; 819       create table svc03 as 820       select s.*, 821           c.v1, p.v5,p.v6 822           from qa20.largetb1 s 826           join qa20.largetb2(keep= v1 v2 v3) c 827           on s.v1= c.v1 828       left join smalltb1 p 829           on s.key= p.key; NOTE: SQL execution methods chosen are:       sqxcrta           sqxjm               sqxsort                   sqxsrc( AA.PROVSPEC1(alias = P) )             sqxsort                   sqxjm                       sqxsrc( QA20.CLAIMS(alias = C) )                       sqxsort                           sqxsrc( QA20.SVCLINES(alias = S) ) ----------------------------------------------------------------------------------------------------------- ... View more