Hi,
I have a select query as shown below. here i am facing the performance issue with the this query. can any one plz suggest the better way to optimize the performance of this query....?
SELECT ekkoebeln ekkoloekz ekkolifnr ekkoekorg ekko~ekgrp
ekpowerks ekpopstyp ekpoloekz ekpoelikz ekpo~menge
ekpomatnr eketebeln eketebelp eketetenr eket~rsnum
eket~eindt INTO
(ekko-ebeln, ekko-loekz, ekko-lifnr, ekko-ekorg, ekko-ekgrp,
ekpo-werks, ekpo-pstyp, ekpo-loekz, ekpo-elikz, ekpo-menge,
ekpo-matnr, eket-ebeln, eket-ebelp, eket-etenr, eket-rsnum,
eket-eindt)
FROM eket INNER JOIN ekpo
ON ( eketebeln = ekpoebeln AND
eketebelp = ekpoebelp )
INNER JOIN ekko
ON ( ekpoebeln = ekkoebeln )
WHERE ekko~ebeln IN ebeln
AND ekko~loekz EQ ' '
AND ekko~lifnr IN lifnr
AND ekko~ekorg IN ekorg
AND ekko~ekgrp IN ekgrp
AND ekpo~werks IN werks
AND ekpo~pstyp EQ '3'
AND ekpo~loekz EQ space
AND ekpo~elikz EQ space
AND ekpo~menge NE 0
AND eket~rsnum NE space.
some statements...
....
endselect.