topic Re: data selecting from mcha poor performance in Application Development and Automation Discussions

data selecting from mcha poor performance

Former Member — Sat, 29 Aug 2009 11:40:38 GMT

Hi experts,

How to improve the performance of below query,

while i have create index on charg(batch number).

SELECT MATNR CHARG FROM mcha
           APPENDING TABLE itab
           WHERE charg IN s_charg .

Re: data selecting from mcha poor performance

Former Member — Sat, 29 Aug 2009 11:44:27 GMT

what is the need of creating index on it? it already is a primary key

Re: data selecting from mcha poor performance

Former Member — Sat, 29 Aug 2009 12:06:26 GMT

ok,

but what should i do????

Re: data selecting from mcha poor performance

Former Member — Sat, 29 Aug 2009 12:09:15 GMT

Hi,

Try to use all the possible primary key fields in the select where condition. The performance would increase considerably.

Regards,

Vikranth

Re: data selecting from mcha poor performance

Clemenss — Sat, 29 Aug 2009 14:32:35 GMT

Hi,

the index is used only if the index fields are supplied in the where condition, i.e. the index of MCHA has MATNR WERKS CHARG. If MATNR is not supplied, the index will never be used.

If you really have no other way (I think you can retrieve the material numbers by analyzing certain movement types of material movements in MKPF and MSEG), then you may create an index on MCHA-CHARG. But you should be aware that this may decrease the performance of many logistics modules.

Try to analyze the requirement in business terms.

Regards,

Clemens

Re: data selecting from mcha poor performance

Former Member — Sat, 05 Sep 2009 07:24:56 GMT

no response long time

Re: data selecting from mcha poor performance

Former Member — Sat, 05 Sep 2009 11:08:27 GMT

Hi Tomar,

You can go for dynamic selection...with this u can possibly send atleast 2-3 or as many input values and pass it on to select stmt...performance can reduce a little bit....

Regards,

Vamshi

Re: data selecting from mcha poor performance

Former Member — Sat, 05 Sep 2009 11:40:40 GMT

hi,

BWTAR is then index field in this table . try to this field in where condition

Jitendra