Skip to Content
0
Former Member
Mar 23, 2009 at 11:01 AM

performance tuning problem

33 Views

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.