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