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?