Skip to Content
0

Run Time Error "Time Limit Exceeded"

Apr 07, 2017 at 11:23 AM

66

avatar image
Former Member

This select query taken 16 minutes for execute .

Any alternative way to increase the performance of select query.

SELECT bukrs
hkont
augdt
augbl
zuonr
gjahr
belnr
buzei
sgtxt
dmbtrINTO TABLE gt_bsisFROM bsisFOR ALL ENTRIES IN gt_acac_objectstWHERE bukrs EQ gt_acac_objectst-bukrs AND
budat LE p_keydt AND
shkzg EQ 'S' AND
sgtxt EQ gt_acac_objectst-lv_sgtxt.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Christopher Solomon
Apr 07, 2017 at 11:26 AM
0

Without looking, I am assuming your "where" is using the fields of the key and in the order of the key. You can also make sure that you have already sorted your "gt_acac_objectst" by the correct key as well.....that will help.

Share
10 |10000 characters needed characters left characters exceeded