performance issue during fetching data from cluster table

[Former Member]

Hi there,

Because of the below select stmt I am getting poor performance.

But in sql trace it is showing KOCLU not KONV table....plz update me here.

SELECT KNUMV KPOSN KSCHL KAWRT KWERT

INTO TABLE I_KONV

FROM KONV

WHERE KSCHL IN ('ZC00','ZS00','MWI2','R100') .

Plz also let me know the suggetions to improve performance..

[Former Member]

hi,

use innerjoin query it will get good performance

thanks,

reward points if helpful...

[Former Member]

Use buferring, which helps you to improve the performance.

U r using WHERE IN condition which is good.

Or beter u can the save 'ZC00','ZS00','MWI2','R100' these in an internal table,

and then u can use

<i>Select for all entries</i> which is comparitively good.

Please reward if helpful.

[kiran_k8]

Tuborg,

KSCHL is neither a primary key nor an index.So obviously it will take time.

First get all the data irrespecitve the KSCHL you had mentioned,into an internal table and then filter the internal table with your requirement.

loop at ifinal.

IF NOT ( itfinal-kschl = 'ZC00' OR itfinal-KSCHL = 'ZS00' OR itfinal-KSChL = 'MW12' OR itfinal-KSCHL = 'R100' )

DELETE ITFINAL.

ENDLOOP.

K.Kiran.

[Former Member]

hi kiran,

I dont think that will give good performance. coz we are going to retreive all the table!

[kiran_k8]

Tuborg,

Retrie all means whatever the data you want from the table not select *.

Always see to that you use only primary key fields or index fields to improve the performance.100% sure.

K.Kiran.

[Former Member]

Hi,

As you are getting the data from cluster table it will have the low performance. Just check if you can reduce your performance, or if you can increase the fields in WHERE clause.

Regards,

Atish