Hello Gurus,
I'm trying to improve the performance of a report. I have the runtime limit fixed to 1800 seconds but I have to access to huge table like Rseg, Ekpo ,or Ekbe most and most of the time the access is with a partial key.
Which of these 2 accesses is more efficient:
select ebeln ebelp zeile belnr gjhar from ekbe into corresponding fields of table it_ekke
where ebeln = it_ekko-ebeln
and ebelp = it_ekko-ebelp.
or it's better doing
select ebeln ebelp zeile belnr gjhar from ekbe appending corresponding fields of table it_ekke package size 10000
where ebeln = it_ekko-ebeln
and ebelp = it_ekko-ebelp.
knowing that it_ekpo has 600000 records.
Thanks.