Query Optimisation

Hi,

We have the following query on REGUP table. This is a cluster table.

SELECT sgtxt FROM regup

INTO l_v_sgtxt

UP TO 1 ROWS

WHERE bukrs = l_v_bukrs1

AND vblnr = l_v_docno1

AND xblnr = l_v_docnummr1

AND gjahr = sy-datum+0(4).

ENDSELECT.

We are facing a lot of issues relating to performance because of the above query. We have milllions of records in the REGUP table and would like to improve performance.

Any solution to improve performance would be greatly appreciated.

Thanks in advance.

Mick