Skip to Content

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

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)

or

(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

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