Skip to Content
Former Member
Oct 15, 2008 at 09:21 AM

Query takes 2 hrs to execute.


Hi Experts,

the following bit of code takes long time to execute(2hrs).

select * from dfttop into table t_dfttop

where vtref1 like u2018YMC%u2019 and

((augbb = u201800000000u2019 and xrag = u2018Xu2019)


(augbb between w_cltfr and w_cltto)) and

zwage_type in s_wtype and

aunnd ne u201803u2019.

Can anyone give me some suggestion. Basically data in zwage_type is very huge. Can some one help me to stream line this and improve the performance.

Edited by: Arun Kumar Sekar on Oct 15, 2008 11:21 AM