Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

performance issue during fetching data from cluster table

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

hi,

use innerjoin query it will get good performance

thanks,

reward points if helpful...

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

hi kiran,

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

kiran_k8
Active Contributor
0 Kudos

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
0 Kudos

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