Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

performance issue

Hi,

I am working on a performance issue.when i checked in ST04 transaction for one of the select statement,it is showing estimated costs as 487.

When I checked in the program that particular select statement,i found that the index is not created on the fields used in the where condition.

given below is the select statement.

SELECT

matnr

charg

sobkz

kunnr

lfgja

lfmon

kulab

FROM msku

INTO TABLE t_msku

FOR ALL ENTRIES IN t_msku_key

WHERE

matnr IN s_matnr

AND werks IN r_werks

AND sobkz IN r_sobkz

AND kunnr = t_msku_key-kunnr

I have checked in DB05 transaction whether it is feasible to create an index on those fields(werks,sobkz,kunnr).

I found the values for werks as 42.126 between 1-10

and 8.923 between 11-100

616 between 101-1.000

sobkz 51.252 between 1-10

8.753 between 11-100

586 between 101-1.000

kunnr 470.434.

is it feasible to create an index on these fields?

Not what you were looking for? View more on this topic or Ask a question