Skip to Content
0
Former Member
May 31, 2007 at 06:02 AM

performance issue

12 Views

Hi Experts,

Kindly let me know how can i improve performance of the below query...

SELECT DISTINCT cbukrs cwaers cprctr bkostl

akstar aversn a~gjahr

awkg001 awkg002 awkg003 awkg004 awkg005 awkg006

awkg007 awkg008 awkg009 awkg010 awkg011 awkg012

awkg013 awkg014 awkg015 awkg016

APPENDING TABLE i_temp

FROM coss AS a

JOIN cssl AS b ON aobjnr = bobjnr

JOIN csks AS c ON bkostl = ckostl

WHERE ( a~lednr EQ '00'

AND a~versn EQ '000'

AND b~kostl IN r_ccde

AND a~wrttp EQ '04'

AND a~gjahr EQ p_fy

AND a~kstar GE '0000000000'

AND a~kstar LE '0000999999' )