Hi,
I have a performance problem with this select statement: Takes 30 to 50 secs.
SELECT k~ebeln k~lifnr k~ekgrp k~ekorg k~bukrs k~bsart
k~bstyp k~bedat k~reswk k~spras k~adrnr
k~waers p~ebelp p~pstyp p~werks p~matnr p~matkl p~txz01
p~idnlf p~labnr
p~elikz p~erekz p~knttp p~vrtkz p~meins p~mfrpn
p~effwr p~netpr p~peinh p~bprme
t~etenr t~eindt t~menge t~wemng t~slfdt t~mahnz
INTO CORRESPONDING FIELDS OF TABLE g_i_tab1
FROM ekko AS k
JOIN ekpo AS p
ON p~ebeln = k~ebeln
JOIN eket AS t
ON t~ebeln = k~ebeln AND
t~ebelp = p~ebelp
WHERE k~lifnr IN s_lifnr AND
k~ekorg IN s_ekorg AND
k~ekgrp IN s_ekgrp AND
k~bedat IN s_bedat AND
k~ebeln IN s_ebeln AND
k~bstyp IN s_bstyp AND
k~bsart IN s_bsart AND
k~loekz = space AND
p~matnr IN s_matnr AND
p~werks IN s_werks AND
p~bstyp IN s_bstyp AND
p~loekz = space AND
p~elikz IN r_elikz AND
p~matkl IN s_matkl AND
p~pstyp IN s_pstyp AND
p~knttp IN s_knttp AND
p~kanba <> 'Y' AND
t~eindt IN s_eindt AND
t~menge > 0 AND
t~menge > t~wemng.
The SQL-Trace (ST05) shows two nested loops, the selection starts always with EKKO
I wonder whether I can force the System to start the selection with Table EKPO, using a certain Index?
(When I count the number of entries with SE16N it takes only 1 sec and I should have the Unique Index to read the other two tables.)
What can I do?
Best regards
Jens