Query takes 2 hrs to execute.
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