Skip to Content
0
Former Member
Mar 31, 2009 at 07:24 AM

I need improve an SQL sentence...

22 Views

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 zmandt zguid_oportunidad zgestor ztipo1 z~tipo2

ztipo3 zestatus zprioridad zcliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON zguid_oportunidad = cguid )

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