Subquery slows down drastically, but they work fine independently

Hi,
select distinct q1.cDocNum,q1.Prod_Exe,q2.Resourse_Vouc,q3.Raw_mater_Issue
From
(select ProdOrder.cDocNum, ProdOrder.dIssueDate,
Case WHEN PrOrdRelated.cDocMode=’202′ […]

Original post by Simtiyaz

Leave a Reply