Skip to Content
0
Former Member
Nov 15, 2012 at 10:08 AM

Performance tuning (runtime limit)

75 Views

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.