Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ROWS Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings TYPE Parallel EstimateExecutions
- ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------
- 3 1 Top(TOP EXPRESSION:((50))) 0 0 Top Top TOP EXPRESSION:((50)) 50 0 5E-006 177 0,164991 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef], [T3].[_Reference77_IDRRef] PLAN_ROW 0 1
- 3 1 |--Nested Loops(Left Anti Semi Join, OUTER REFERENCES:([T1].[_Fld13011RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T3].[_Reference77_IDRRef])) 0 1 0 Nested Loops Left Anti Semi Join OUTER REFERENCES:([T1].[_Fld13011RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T3].[_Reference77_IDRRef]) 50 0 3,77511 177 0,164986 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef], [T3].[_Reference77_IDRRef] PLAN_ROW 0 1
- 902310 1 |--Nested Loops(Inner Join) 0 2 1 Nested Loops Inner Join 55,5556 0 3,77511 177 0,00931134 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef], [T3].[_Reference77_IDRRef] NO JOIN PREDICATE PLAN_ROW 0 1
- 150385 1 | |--Clustered Index Scan(OBJECT:([LocalBase].[dbo].[_Document517].[PK___Document517NG__2E5FFDE1] AS [T1])) 0 3 2 Clustered Index Scan Clustered Index Scan OBJECT:([LocalBase].[dbo].[_Document517].[PK___Document517NG__2E5FFDE1] AS [T1]) [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef] 9,25078 15,9142 0,16558 161 0,00416513 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef] PLAN_ROW 0 1
- 902310 150385 | |--Stream Aggregate(GROUP BY:([T3].[_Reference77_IDRRef])) 0 4 2 Stream Aggregate Aggregate GROUP BY:([T3].[_Reference77_IDRRef]) 6,0055 0 6,0055E-006 23 0,00486364 [T3].[_Reference77_IDRRef] PLAN_ROW 0 10,2507
- 902310 150385 | |--Index Seek(OBJECT:([LocalBase].[dbo].[_Reference77_VT2072].[_Referenc77_VT2072_ByField2075_RR] AS [T3]), SEEK:([T3].[_Fld2074RRef]=[@P1]) ORDERED FORWARD) 0 5 4 Index Seek Index Seek OBJECT:([LocalBase].[dbo].[_Reference77_VT2072].[_Referenc77_VT2072_ByField2075_RR] AS [T3]), SEEK:([T3].[_Fld2074RRef]=[@P1]) ORDERED FORWARD [T3].[_Reference77_IDRRef] 6,0055 0,003125 0,000163606 23 0,00480208 [T3].[_Reference77_IDRRef] PLAN_ROW 0 10,2507
- 902307 902310 |--Filter(WHERE:([LocalBase].[dbo].[_InfoRg20970].[_Fld20971_TYPE] as [T5].[_Fld20971_TYPE] IS NULL AND [LocalBase].[dbo].[_InfoRg20970].[_Fld20971_RTRef] as [T5].[_Fld20971_RTRef] IS NULL AND [LocalBase].[dbo].[_InfoRg20970].[_Fld20971_RRRef] as [T5].[_Fld20971_RRRef] IS NULL)) 0 7 1 Filter Filter WHERE:([LocalBase].[dbo].[_InfoRg20970].[_Fld20971_TYPE] as [T5].[_Fld20971_TYPE] IS NULL AND [LocalBase].[dbo].[_InfoRg20970].[_Fld20971_RTRef] as [T5].[_Fld20971_RTRef] IS NULL AND [LocalBase].[dbo].[_InfoRg20970].[_Fld20971_RRRef] as [T5].[_Fld20971_RRRef] IS NULL) 1 0 3,6917E-006 9 0,164991 PLAN_ROW 0 101,002
- 914162 902310 |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T4].[_Fld20899RRef], [Expr1014])) 0 8 7 Nested Loops Left Outer Join OUTER REFERENCES:([T4].[_Fld20899RRef], [Expr1014]) 3,12856 0 1,30774E-005 28 0,164991 [T5].[_Fld20971_TYPE], [T5].[_Fld20971_RTRef], [T5].[_Fld20971_RRRef] PLAN_ROW 0 101,002
- 0 0 |--Compute Scalar(DEFINE:([Expr1014]=CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x909D005E4CAF2E8D472C07D30D9D40AF THEN 0x000000A8 ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x9E80A570B3B742FB44770FC3B9C6ACCD THEN 0x000000BA ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x8866D1BC98777B4946D5231F78946040 THEN 0x000000F2 ELSE NULL END END END)) 0 9 8 Compute Scalar Compute Scalar DEFINE:([Expr1014]=CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x909D005E4CAF2E8D472C07D30D9D40AF THEN 0x000000A8 ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x9E80A570B3B742FB44770FC3B9C6ACCD THEN 0x000000BA ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x8866D1BC98777B4946D5231F78946040 THEN 0x000000F2 ELSE NULL END END END) [Expr1014]=CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x909D005E4CAF2E8D472C07D30D9D40AF THEN 0x000000A8 ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x9E80A570B3B742FB44770FC3B9C6ACCD THEN 0x000000BA ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x8866D1BC98777B4946D5231F78946040 THEN 0x000000F2 ELSE NULL END END END 1,95035 0 1,95035E-007 29 0,0348438 [T4].[_Fld20899RRef], [Expr1014] PLAN_ROW 0 101,002
- 914162 902310 | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1033], [Expr1034], [Expr1035])) 0 10 9 Nested Loops Inner Join OUTER REFERENCES:([Expr1033], [Expr1034], [Expr1035]) 1,95035 0,003125 0,000159145 23 0,0348241 [T4].[_Fld20899RRef] PLAN_ROW 0 101,002
- 1828324 902310 | |--Merge Interval 0 11 10 Merge Interval Merge Interval 4 0 0 0 0 [Expr1033], [Expr1034], [Expr1035] PLAN_ROW 0 1
- 2718782 902310 | | |--Sort(TOP 4, ORDER BY:([Expr1036] DESC, [Expr1037] ASC, [Expr1033] ASC, [Expr1038] DESC)) 0 12 11 Sort TopN Sort TOP 4, ORDER BY:([Expr1036] DESC, [Expr1037] ASC, [Expr1033] ASC, [Expr1038] DESC) 4 0 0 0 0 [Expr1033], [Expr1034], [Expr1035], [Expr1036], [Expr1037], [Expr1038] PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([Expr1036]=((4)&[Expr1035]) = (4) AND NULL = [Expr1033], [Expr1037]=(4)&[Expr1035], [Expr1038]=(16)&[Expr1035])) 0 13 12 Compute Scalar Compute Scalar DEFINE:([Expr1036]=((4)&[Expr1035]) = (4) AND NULL = [Expr1033], [Expr1037]=(4)&[Expr1035], [Expr1038]=(16)&[Expr1035]) [Expr1036]=((4)&[Expr1035]) = (4) AND NULL = [Expr1033], [Expr1037]=(4)&[Expr1035], [Expr1038]=(16)&[Expr1035] 4 0 0 0 0 [Expr1033], [Expr1034], [Expr1035], [Expr1036], [Expr1037], [Expr1038] PLAN_ROW 0 1
- 3609240 902310 | | |--Concatenation 0 14 13 Concatenation Concatenation [Expr1033] = ([@P7], [@P6], [@P5], [@P4]), [Expr1034] = ([@P7], [@P6], [@P5], [@P4]), [Expr1035] = ([Expr1021], [Expr1024], [Expr1027], [Expr1030]) 4 0 0 0 0 [Expr1033], [Expr1034], [Expr1035] PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([@P7]=[@P7], [@P7]=[@P7], [Expr1021]=(62))) 0 15 14 Compute Scalar Compute Scalar DEFINE:([@P7]=[@P7], [@P7]=[@P7], [Expr1021]=(62)) [@P7]=[@P7], [@P7]=[@P7], [Expr1021]=(62) 1 0 0 0 0 [@P7], [@P7], [Expr1021] PLAN_ROW 0 1
- 902310 902310 | | | |--Constant Scan 0 16 15 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([@P6]=[@P6], [@P6]=[@P6], [Expr1024]=(62))) 0 24 14 Compute Scalar Compute Scalar DEFINE:([@P6]=[@P6], [@P6]=[@P6], [Expr1024]=(62)) [@P6]=[@P6], [@P6]=[@P6], [Expr1024]=(62) 1 0 0 0 0 [@P6], [@P6], [Expr1024] PLAN_ROW 0 1
- 902310 902310 | | | |--Constant Scan 0 25 24 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([@P5]=[@P5], [@P5]=[@P5], [Expr1027]=(62))) 0 33 14 Compute Scalar Compute Scalar DEFINE:([@P5]=[@P5], [@P5]=[@P5], [Expr1027]=(62)) [@P5]=[@P5], [@P5]=[@P5], [Expr1027]=(62) 1 0 0 0 0 [@P5], [@P5], [Expr1027] PLAN_ROW 0 1
- 902310 902310 | | | |--Constant Scan 0 34 33 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([@P4]=[@P4], [@P4]=[@P4], [Expr1030]=(62))) 0 42 14 Compute Scalar Compute Scalar DEFINE:([@P4]=[@P4], [@P4]=[@P4], [Expr1030]=(62)) [@P4]=[@P4], [@P4]=[@P4], [Expr1030]=(62) 1 0 0 0 0 [@P4], [@P4], [Expr1030] PLAN_ROW 0 1
- 902310 902310 | | |--Constant Scan 0 43 42 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
- 914162 1828324 | |--Clustered Index Seek(OBJECT:([LocalBase].[dbo].[_InfoRg20897].[_InfoR20897_ByDims_RR] AS [T4]), SEEK:([T4].[_Fld20898RRef]=[LocalBase].[dbo].[_Reference77_VT2072].[_Reference77_IDRRef] as [T3].[_Reference77_IDRRef] AND [T4].[_Fld20899RRef] > [Expr1033] AND [T4].[_Fld20899RRef] < [Expr1034]) ORDERED FORWARD) 0 58 10 Clustered Index Seek Clustered Index Seek OBJECT:([LocalBase].[dbo].[_InfoRg20897].[_InfoR20897_ByDims_RR] AS [T4]), SEEK:([T4].[_Fld20898RRef]=[LocalBase].[dbo].[_Reference77_VT2072].[_Reference77_IDRRef] as [T3].[_Reference77_IDRRef] AND [T4].[_Fld20899RRef] > [Expr1033] AND [T4].[_Fld20899RRef] < [Expr1034]) ORDERED FORWARD [T4].[_Fld20899RRef] 1,95035 0,003125 0,000159145 23 0,0348241 [T4].[_Fld20899RRef] PLAN_ROW 0 101,002
- 11855 914162 |--Index Seek(OBJECT:([LocalBase].[dbo].[_InfoRg20970].[_InfoR20970_ByDims20980_RRRRRL] AS [T5]), SEEK:([T5].[_Fld20974RRef]=[LocalBase].[dbo].[_Reference77_VT2072].[_Reference77_IDRRef] as [T3].[_Reference77_IDRRef] AND [T5].[_Fld20971_TYPE]=CASE WHEN [Expr1014] IS NOT NULL THEN [@P3] ELSE NULL END AND [T5].[_Fld20971_RTRef]=[Expr1014] AND [T5].[_Fld20971_RRRef]=CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x909D005E4CAF2E8D472C07D30D9D40AF THEN [LocalBase].[dbo].[_Document517].[_Fld13011RRef] as [T1].[_Fld13011RRef] ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x9E80A570B3B742FB44770FC3B9C6ACCD THEN [LocalBase].[dbo].[_Document517].[_Fld13061RRef] as [T1].[_Fld13061RRef] ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x8866D1BC98777B4946D5231F78946040 THEN [LocalBase].[dbo].[_Document517].[_Fld13042RRef] as [T1].[_Fld13042RRef] ELSE NULL END END END AND [T5].[_Fld20972RRef]=[LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef] AND [T5].[_Fld20973RRef]=[@P4]) ORDERED FORWARD) 0 62 8 Index Seek Index Seek OBJECT:([LocalBase].[dbo].[_InfoRg20970].[_InfoR20970_ByDims20980_RRRRRL] AS [T5]), SEEK:([T5].[_Fld20974RRef]=[LocalBase].[dbo].[_Reference77_VT2072].[_Reference77_IDRRef] as [T3].[_Reference77_IDRRef] AND [T5].[_Fld20971_TYPE]=CASE WHEN [Expr1014] IS NOT NULL THEN [@P3] ELSE NULL END AND [T5].[_Fld20971_RTRef]=[Expr1014] AND [T5].[_Fld20971_RRRef]=CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x909D005E4CAF2E8D472C07D30D9D40AF THEN [LocalBase].[dbo].[_Document517].[_Fld13011RRef] as [T1].[_Fld13011RRef] ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x9E80A570B3B742FB44770FC3B9C6ACCD THEN [LocalBase].[dbo].[_Document517].[_Fld13061RRef] as [T1].[_Fld13061RRef] ELSE CASE WHEN [LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef]=0x8866D1BC98777B4946D5231F78946040 THEN [LocalBase].[dbo].[_Document517].[_Fld13042RRef] as [T1].[_Fld13042RRef] ELSE NULL END END END AND [T5].[_Fld20972RRef]=[LocalBase].[dbo].[_InfoRg20897].[_Fld20899RRef] as [T4].[_Fld20899RRef] AND [T5].[_Fld20973RRef]=[@P4]) ORDERED FORWARD [T5].[_Fld20971_TYPE], [T5].[_Fld20971_RTRef], [T5].[_Fld20971_RRRef] 1,6041 0,003125 0,000158765 28 0,164991 [T5].[_Fld20971_TYPE], [T5].[_Fld20971_RTRef], [T5].[_Fld20971_RRRef] PLAN_ROW 0 196,991
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement