Select query on EABLG & EABL taking long time

[vikrant_guptarya]

Hi Experts,

We have this code running for almost 4 years now. suddenly this piece of code has started taking 10 times more time.

I believe no increase in data in these tables could have increased the access time by 10 times in the last 4 days. We have also ran the stats for the table EABLG & EABL, but still the performance has not improved.

Please let me know if there is any remedy for this or should i raise a OSS message for this.

SELECT e~anlage

e~ablesgr

a~ablstat

e~adatsoll

FROM eablg AS e INNER JOIN

eabl AS a

ON e_{ablbelnr = a}ablbelnr

INTO TABLE it_eabl_eablg

WHERE a~ablstat EQ '0'

AND e~ablesgr EQ '06'

AND e~anlage IN s_anlage.

IF it_eabl_eablg[] IS NOT INITIAL.

SELECT e1~anlage

e1~ablesgr

a1~ablstat

e1~adatsoll

FROM eablg AS e1 INNER JOIN

eabl AS a1

ON e1_{ablbelnr = a1}ablbelnr

INTO TABLE it_eabl_eablg1

FOR ALL ENTRIES IN it_eabl_eablg

WHERE e1~anlage = it_eabl_eablg-anlage

AND e1~ablesgr EQ '03'.

[vikrant_guptarya]

Just to add, my MR upload timings have also been affected from the same day. I guess that the reason has to be definitely other than code tuning.

[Former Member]

Hi Vikrant,

Can you check table indexes on EABLG and EABL. If someone added or deleted some of the indexes, might be causing reading and writing to these tables taking extra bit of time.

Regards,

Avinash

[vikrant_guptarya]

Thanks avinash... seems effect of stat update kicked in only after a day