topic Re: Select afru slow in Application Development and Automation Discussions

Select afru slow

Former Member — Wed, 30 Sep 2009 18:31:29 GMT

Hi,

I'm doing the following SELECT.

SELECT pernr

aufnr

ismne

ismnw

meinh

budat

catsbelnr

isdd

FROM afru

INTO TABLE t_afru

FOR ALL ENTRIES IN t_pa0000

WHERE pernr = t_pa0000-pernr AND

isdd BETWEEN v_ct_date_fr AND v_ct_date_to

AND catsbelnr EQ ''

AND stokz NE 'X'

AND stzhl EQ 0.

This taking too long, how could it improve performance?

Re: Select afru slow

Former Member — Thu, 01 Oct 2009 04:33:48 GMT

Hi,

Thats because you are not using the primary keys RUECK and RMZHL in the where condition of the select which is affecting the performance.

If it is not possible to use the primary keys, then try creating a secondary index on the field pernr and isdd. That will considerably increase the performance.

Also use the condition if not t_pa0000[] is initial before the select query since you are using FOR ALL ENTRIES.

Regards,

Vikranth

Re: Select afru slow

Former Member — Thu, 01 Oct 2009 10:56:00 GMT

Hi,

Do you know any way to get this information and RUECK RMZHL to improve performance?

At the moment I will not be able to insert indec.

Thanks

Rafael Fassoli