Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

In how many ways we can filter this select statement to improve performance

Hi Experts,

This select statement taking 2.5 hrs in production, Can we filter the where condition, to improve the performance.Plz suggest with coding ASAP.

select * from dfkkop into table t_dfkkop

where vtref like 'EPC%' and

( ( augbd = '00000000' and

xragl = 'X' )

or

( augbd between w_clrfr and w_clrto ) ) and

augrd ne '03' and

zwage_type in s_wtype .

Regards,

Sam.

Not what you were looking for? View more on this topic or Ask a question