Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 40 1 Top(TOP EXPRESSION:((40))) 0 0 Top Top TOP EXPRESSION:((40)) 40 0 4E-006 55 0,141474 [T1].[_IDRRef], [T1].[_Marked], [T1].[_Date_Time], [T1].[_Number], [T1].[_Posted] PLAN_ROW 0 1 40 1 |--Nested Loops(Left Semi Join, OUTER REFERENCES:([T1].[_Fld15101RRef])) 0 1 0 Nested Loops Left Semi Join OUTER REFERENCES:([T1].[_Fld15101RRef]) 40 0 0,00770792 55 0,14147 [T1].[_IDRRef], [T1].[_Marked], [T1].[_Date_Time], [T1].[_Number], [T1].[_Posted] PLAN_ROW 0 1 41 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([T1].[_IDRRef], [Expr1022]) WITH ORDERED PREFETCH) 0 2 1 Nested Loops Inner Join OUTER REFERENCES:([T1].[_IDRRef], [Expr1022]) WITH ORDERED PREFETCH 44,4444 0 0,00770792 71 0,126853 [T1].[_IDRRef], [T1].[_Marked], [T1].[_Date_Time], [T1].[_Number], [T1].[_Posted], [T1].[_Fld15101RRef] PLAN_ROW 0 1 217 1 | |--Index Scan(OBJECT:([UPP].[dbo].[_Document556].[_Documen556_ByDocDate_TRL] AS [T1]), ORDERED FORWARD) 0 4 2 Index Scan Index Scan OBJECT:([UPP].[dbo].[_Document556].[_Documen556_ByDocDate_TRL] AS [T1]), ORDERED FORWARD [T1].[_IDRRef], [T1].[_Marked], [T1].[_Date_Time] 44,4444 0,0134954 0,0021854 32 0,00357535 [T1].[_IDRRef], [T1].[_Marked], [T1].[_Date_Time] PLAN_ROW 0 1 41 41 | |--Clustered Index Seek(OBJECT:([UPP].[dbo].[_Document556].[PK___Documen__AC8ED0C401D5A7B5] AS [T1]), SEEK:([T1].[_IDRRef]=[UPP].[dbo].[_Document556].[_IDRRef] as [T1].[_IDRRef]) LOOKUP ORDERED FORWARD) 0 6 2 Clustered Index Seek Clustered Index Seek OBJECT:([UPP].[dbo].[_Document556].[PK___Documen__AC8ED0C401D5A7B5] AS [T1]), SEEK:([T1].[_IDRRef]=[UPP].[dbo].[_Document556].[_IDRRef] as [T1].[_IDRRef]) LOOKUP ORDERED FORWARD [T1].[_Number], [T1].[_Posted], [T1].[_Fld15101RRef] 1 0,003125 0,0001581 46 0,123092 [T1].[_Number], [T1].[_Posted], [T1].[_Fld15101RRef] PLAN_ROW 0 45,4203 40 41 |--Row Count Spool 0 14 1 Row Count Spool Lazy Spool 1 0 0,0001001 9 0,0179974 PLAN_ROW 0 81,0482 2 3 |--Nested Loops(Left Anti Semi Join, OUTER REFERENCES:([Expr1005])) 0 15 14 Nested Loops Left Anti Semi Join OUTER REFERENCES:([Expr1005]) 1 0 4,18E-006 9 0,00988444 PLAN_ROW 0 1,0482 3 3 |--Stream Aggregate(GROUP BY:([Expr1005])) 0 16 15 Stream Aggregate Aggregate GROUP BY:([Expr1005]) 1 0 2E-006 23 0,00329544 [Expr1005] PLAN_ROW 0 1,0482 0 0 | |--Compute Scalar(DEFINE:([Expr1005]=[UPP].[dbo].[_Reference82_VT2176].[_Reference82_IDRRef] as [T3].[_Reference82_IDRRef])) 0 17 16 Compute Scalar Compute Scalar DEFINE:([Expr1005]=[UPP].[dbo].[_Reference82_VT2176].[_Reference82_IDRRef] as [T3].[_Reference82_IDRRef]) [Expr1005]=[UPP].[dbo].[_Reference82_VT2176].[_Reference82_IDRRef] as [T3].[_Reference82_IDRRef] 3 0 3E-007 39 0,00329334 [T3].[_Reference82_IDRRef], [Expr1005] PLAN_ROW 0 1,0482 3 3 | |--Index Seek(OBJECT:([UPP].[dbo].[_Reference82_VT2176].[_Referenc82_VT2176_ByField2179_RR] AS [T3]), SEEK:([T3].[_Fld2178RRef]=[@P1]) ORDERED FORWARD) 0 18 17 Index Seek Index Seek OBJECT:([UPP].[dbo].[_Reference82_VT2176].[_Referenc82_VT2176_ByField2179_RR] AS [T3]), SEEK:([T3].[_Fld2178RRef]=[@P1]) ORDERED FORWARD [T3].[_Reference82_IDRRef] 3 0,003125 0,0001603 23 0,00329303 [T3].[_Reference82_IDRRef] PLAN_ROW 0 1,0482 1 3 |--Filter(WHERE:([UPP].[dbo].[_InfoRg22055].[_Fld22056_TYPE] as [T5].[_Fld22056_TYPE] IS NULL AND [UPP].[dbo].[_InfoRg22055].[_Fld22056_RTRef] as [T5].[_Fld22056_RTRef] IS NULL AND [UPP].[dbo].[_InfoRg22055].[_Fld22056_RRRef] as [T5].[_Fld22056_RRRef] IS NULL)) 0 23 15 Filter Filter WHERE:([UPP].[dbo].[_InfoRg22055].[_Fld22056_TYPE] as [T5].[_Fld22056_TYPE] IS NULL AND [UPP].[dbo].[_InfoRg22055].[_Fld22056_RTRef] as [T5].[_Fld22056_RTRef] IS NULL AND [UPP].[dbo].[_InfoRg22055].[_Fld22056_RRRef] as [T5].[_Fld22056_RRRef] IS NULL) 1 0 1,18E-006 9 0,00658462 PLAN_ROW 0 1,0482 3 3 |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T4].[_Fld21963RRef])) 0 24 23 Nested Loops Left Outer Join OUTER REFERENCES:([T4].[_Fld21963RRef]) 1 0 4,18E-006 28 0,00658338 [T5].[_Fld22056_TYPE], [T5].[_Fld22056_RTRef], [T5].[_Fld22056_RRRef] PLAN_ROW 0 1,0482 3 3 |--Clustered Index Scan(OBJECT:([UPP].[dbo].[_InfoRg21961].[_InfoR21961_ByDims_RR] AS [T4]), WHERE:([UPP].[dbo].[_InfoRg21961].[_Fld21962RRef] as [T4].[_Fld21962RRef]=[Expr1005] AND ([UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P7] OR [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P6]))) 0 25 24 Clustered Index Scan Clustered Index Scan OBJECT:([UPP].[dbo].[_InfoRg21961].[_InfoR21961_ByDims_RR] AS [T4]), WHERE:([UPP].[dbo].[_InfoRg21961].[_Fld21962RRef] as [T4].[_Fld21962RRef]=[Expr1005] AND ([UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P7] OR [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P6])) [T4].[_Fld21963RRef] 1 0,0032035 7,96E-005 39 0,00328694 [T4].[_Fld21963RRef] PLAN_ROW 0 1,0482 2 3 |--Index Seek(OBJECT:([UPP].[dbo].[_InfoRg22055].[_InfoR22055_ByDims22065_RRRRRL] AS [T5]), SEEK:([T5].[_Fld22059RRef]=[Expr1005] AND [T5].[_Fld22056_TYPE]=CASE WHEN CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P2] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END IS NOT NULL THEN 0x08 ELSE NULL END AND [T5].[_Fld22056_RTRef]=CASE WHEN CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P3] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END IS NOT NULL THEN 0x000000B1 ELSE NULL END AND [T5].[_Fld22056_RRRef]=CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P4] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END AND [T5].[_Fld22057RRef]=[UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef] AND [T5].[_Fld22058RRef]=[@P5]) ORDERED FORWARD) 0 26 24 Index Seek Index Seek OBJECT:([UPP].[dbo].[_InfoRg22055].[_InfoR22055_ByDims22065_RRRRRL] AS [T5]), SEEK:([T5].[_Fld22059RRef]=[Expr1005] AND [T5].[_Fld22056_TYPE]=CASE WHEN CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P2] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END IS NOT NULL THEN 0x08 ELSE NULL END AND [T5].[_Fld22056_RTRef]=CASE WHEN CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P3] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END IS NOT NULL THEN 0x000000B1 ELSE NULL END AND [T5].[_Fld22056_RRRef]=CASE WHEN [UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef]=[@P4] THEN [UPP].[dbo].[_Document556].[_Fld15101RRef] as [T1].[_Fld15101RRef] ELSE NULL END AND [T5].[_Fld22057RRef]=[UPP].[dbo].[_InfoRg21961].[_Fld21963RRef] as [T4].[_Fld21963RRef] AND [T5].[_Fld22058RRef]=[@P5]) ORDERED FORWARD [T5].[_Fld22056_TYPE], [T5].[_Fld22056_RTRef], [T5].[_Fld22056_RRRef] 1 0,003125 0,0001581 28 0,00329072 [T5].[_Fld22056_TYPE], [T5].[_Fld22056_RTRef], [T5].[_Fld22056_RRRef] PLAN_ROW 0 1,0482