API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 4th, 2019
119
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 74.79 KB | None | 0 0
raw download clone embed print report
  1. Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
  2. ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------
  3. 50 1 Top(TOP EXPRESSION:((50))) 0 0 Top Top TOP EXPRESSION:((50)) 50 0 5E-006 161 0,165476 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef] PLAN_ROW 0 1
  4. 50 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,14401 161 0,165471 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef] PLAN_ROW 0 1
  5. 941 1 |--Nested Loops(Inner Join) 0 2 1 Nested Loops Inner Join 55,5556 0 3,14401 177 0,00979257 [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
  6. 236 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] 11,1077 15,9142 0,16558 161 0,00436365 [T1].[_IDRRef], [T1].[_Fld13011RRef], [T1].[_Fld13013RRef], [T1].[_Fld13020], [T1].[_Fld13021RRef], [T1].[_Fld13040RRef], [T1].[_Fld13041RRef], [T1].[_Fld13042RRef], [T1].[_Fld13061RRef], [T1].[_Fld13082RRef] PLAN_ROW 0 1
  7. 941 236 | |--Stream Aggregate(GROUP BY:([T3].[_Reference77_IDRRef])) 0 4 2 Stream Aggregate Aggregate GROUP BY:([T3].[_Reference77_IDRRef]) 5,00153 0 5,00153E-006 23 0,00515307 [T3].[_Reference77_IDRRef] PLAN_ROW 0 12,1076
  8. 942 236 | |--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] 5,00153 0,003125 0,000162502 23 0,00509251 [T3].[_Reference77_IDRRef] PLAN_ROW 0 12,1076
  9. 891 941 |--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,165476 PLAN_ROW 0 101,002
  10. 1031 941 |--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,165476 [T5].[_Fld20971_TYPE], [T5].[_Fld20971_RTRef], [T5].[_Fld20971_RRRef] PLAN_ROW 0 101,002
  11. 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,0348437 [T4].[_Fld20899RRef], [Expr1014] PLAN_ROW 0 101,002
  12. 1031 941 | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1030], [Expr1031], [Expr1032])) 0 10 9 Nested Loops Inner Join OUTER REFERENCES:([Expr1030], [Expr1031], [Expr1032]) 1,95035 0,003125 0,000159145 23 0,034824 [T4].[_Fld20899RRef] PLAN_ROW 0 101,002
  13. 1121 941 | |--Merge Interval 0 11 10 Merge Interval Merge Interval 3 0 0 0 0 [Expr1030], [Expr1031], [Expr1032] PLAN_ROW 0 1
  14. 1972 941 | | |--Sort(TOP 3, ORDER BY:([Expr1033] DESC, [Expr1034] ASC, [Expr1030] ASC, [Expr1035] DESC)) 0 12 11 Sort TopN Sort TOP 3, ORDER BY:([Expr1033] DESC, [Expr1034] ASC, [Expr1030] ASC, [Expr1035] DESC) 3 0 0 0 0 [Expr1030], [Expr1031], [Expr1032], [Expr1033], [Expr1034], [Expr1035] PLAN_ROW 0 1
  15. 0 0 | | |--Compute Scalar(DEFINE:([Expr1033]=((4)&[Expr1032]) = (4) AND NULL = [Expr1030], [Expr1034]=(4)&[Expr1032], [Expr1035]=(16)&[Expr1032])) 0 13 12 Compute Scalar Compute Scalar DEFINE:([Expr1033]=((4)&[Expr1032]) = (4) AND NULL = [Expr1030], [Expr1034]=(4)&[Expr1032], [Expr1035]=(16)&[Expr1032]) [Expr1033]=((4)&[Expr1032]) = (4) AND NULL = [Expr1030], [Expr1034]=(4)&[Expr1032], [Expr1035]=(16)&[Expr1032] 3 0 0 0 0 [Expr1030], [Expr1031], [Expr1032], [Expr1033], [Expr1034], [Expr1035] PLAN_ROW 0 1
  16. 2823 941 | | |--Concatenation 0 14 13 Concatenation Concatenation [Expr1030] = ([@P7], [@P6], [@P5]), [Expr1031] = ([@P7], [@P6], [@P5]), [Expr1032] = ([Expr1021], [Expr1024], [Expr1027]) 3 0 0 0 0 [Expr1030], [Expr1031], [Expr1032] PLAN_ROW 0 1
  17. 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
  18. 941 941 | | | |--Constant Scan 0 16 15 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
  19. 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
  20. 941 941 | | | |--Constant Scan 0 25 24 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
  21. 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
  22. 941 941 | | |--Constant Scan 0 34 33 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1
  23. 1031 1121 | |--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] > [Expr1030] AND [T4].[_Fld20899RRef] < [Expr1031]) ORDERED FORWARD) 0 49 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] > [Expr1030] AND [T4].[_Fld20899RRef] < [Expr1031]) ORDERED FORWARD [T4].[_Fld20899RRef] 1,95035 0,003125 0,000159145 23 0,034824 [T4].[_Fld20899RRef] PLAN_ROW 0 101,002
  24. 140 1031 |--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 53 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,165476 [T5].[_Fld20971_TYPE], [T5].[_Fld20971_RTRef], [T5].[_Fld20971_RRRef] PLAN_ROW 0 196,99
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!