Hello,
I am using a big query using join statement filtering as per month from table having millons of data.
It's taking to much time to give result, how can I increase it's speed .
Query is
declare @TOwner as nvarchar(50)
set @TOwner='MRCPL'
declare @Month AS nvarchar(500)
set @Month='May'
Select A.Source_Abrevation,A.SourceID,D.Qty,A.PayRate,A.Timer,A.BillRate,B.T_Owner,C.MRCQty,B.MRCBillRate from
(
select TK.T_Owner,SAM.Source_Abrevation,SAM.SourceID,
convert(nvarchar(4),TRM.OutTime,109) as MRCTimer,
sum(Convert(DECIMAL,DOOC.EnteredQuantity))as MRCQty,
sum(convert(DECIMAL,CDD.CDLoadAmount))as MRCBillRate
from Child_Despatch CDD
inner join DO_Child DOOC on DOOC.DO_Child=CDD.DO_Child
inner join DO_Master DOOM on DOOM.DOID=DOOC.DOID
inner join Trip_Master TRM on TRM.TripID=DOOM.TripID
inner join Source_Master SAM on SAM.SourceID=TRM.Trip_Source ...
Go to the complete details ...