Run Time Error "Time Limit Exceeded"

[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.

[ChrisSolomon]

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.