I need improve an SQL sentence...

Hi people,

This question is linked with SQL test issue in:

[;

I 've this SQL sentence:

DATA: it_ges LIKE zcctbltar OCCURS 0 WITH HEADER LINE.

CONSTANTS: l_c_si(2) TYPE c VALUE 'SI'.

SELECT z_{mandt z}guid_oportunidad z_{gestor z}tipo1 z~tipo2

z_{tipo3 z}estatus z_{prioridad z}cliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON z_{guid_oportunidad = c}guid )

WHERE z~tipo2 = 'ZAP'

AND c~zztexto27 = l_c_si.

This sentence needs 6,5 Seconds in INTEGRATION environmet (ZCCTBLTAR have 39.882 items, CRMD_ORDERADM_H have 1.853.334 items).

The problem is that I need do this process more fast than actually. In PRODUCTION environment, We have 3.179.867 items in CRM_ORDERADM_H (double than INTEGRATION).

¿Do U know how optimize this SELECT?

Thanks,

Sergio