Skip to Content
0
Former Member
Sep 20, 2008 at 11:27 AM

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

55 Views

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.