Performance Issue

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Try this :

1. do not use appending table clause.

2. use index keys in joins

Hope this will help.

[Former Member]

hi jogdand,

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

[Former Member]

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

[Former Member]

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 )

[Former Member]

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