Skip to Content
0
Former Member
Dec 08, 2008 at 07:51 AM

performence probelm

34 Views

Moved to correct forum by moderator. Please use a meaningful subject in future.

Hi All,

I am fetching data from EKPO, where I am using the below in my where conditions. Other than this I donu2019t have much suitable condition. As I am not using proper key the performance is getting problem now.

Select fld1 fld2 fld3 from EKPO into table I_EKPO where

AND loekz = ' '

AND pstyp <> '5'

AND knttp NOT IN ('C' ,'2').

So can anyone suggest me to improve the performance of select query? like how to avoid not conditions as this will kills the perfrmence.

Edited by: Matt on Dec 8, 2008 9:20 AM