topic Re: Performance Issue in Application Development and Automation Discussions

Performance Issue

Former Member — Tue, 10 Apr 2007 03:47:17 GMT

This statement is taking more time.

How to improve the performance of this statement

SELECT DISTINCT c_{bukrs c}waers c_{prctr b}kostl

a_{kstar a}versn a~gjahr

a_{p001 a}p002 a_{p003 a}p004 a_{p005 a}p006

a_{p007 a}p008 a_{p009 a}p010 a_{p011 a}p012

a_{p013 a}p014 a_{p015 a}p016

APPENDING TABLE itab_temp

FROM zvcoss AS a

JOIN zvcssl AS b ON a_{objnr = b}objnr

JOIN zkcsks AS c ON b_{kostl = c}kostl

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' ) .

Re: Performance Issue

Former Member — Tue, 10 Apr 2007 04:40:48 GMT

try to minimize conditins in where clasue

ranges : r_kstar for zvcoss-kstar.

r_kstar-option = 'BT'

r_kstar-sign = 'I'

r_kstar-low = '0000000000'.

r_kstar-high = '0000999999' .

append r_kstar.

clear r_kstar.

<b>AND a~kstar in r_kstar.</b>

regards

Prabhu

Re: Performance Issue

Former Member — Tue, 10 Apr 2007 04:50:18 GMT

Hi,

Try this :

1. do not use appending table clause.

2. use index keys in joins

Hope this will help.

Re: Performance Issue

Former Member — Tue, 10 Apr 2007 05:00:54 GMT

hi jogdand,

can you tell me clearly abt the index key u have mentioned

Re: Performance Issue

Former Member — Tue, 10 Apr 2007 08:59:50 GMT

Hi,

1.Avoid APPENDING CLAUSE in the select query.instead use temporary internal table and move into the final internal table.

2. Split the joins.

You can first go for a join on zkcsks and zvcssl and fetch the required records.

delete the duplicate entries and check if the table is inital. and then for all entries to fetch the data from zvcoss .

regards,

madhu

Re: Performance Issue

Former Member — Wed, 11 Apr 2007 12:24:47 GMT

1.Select Distinct will cause perfromance issues, try to select the entire data and then use delete adjacent duplicates statement.

2. Try using brackets as given below for the join:

FROM ( ( zvcoss AS a JOIN zvcssl AS b

ON a_{objnr = b}objnr )

JOIN zkcsks AS c ON b_{kostl = c}kostl )

Re: Performance Issue

Former Member — Wed, 11 Apr 2007 14:25:53 GMT

hi,

please remove distinct.

it will try to modify the database when executing this select and the results can be quite dangerous.

even now if the perfromance does not improve try For all entries statement..

thanks

Sunder