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
- 4616 1 SELECT ROW_NUMBER() OVER(ORDER BY c.field2, c.field1) AS RowNumber, a.t1_t3ID, c.field1, c.field2, a.t1_t2ID, b.field1, a.BeginDate, a.EndDate, c.field3 FROM table1 a INNER JOIN table3 p ON a.t1_t3ID = c.p3_PKID INNER JOIN table2 b ON a.t1_t2ID = b.t2_PKID WHERE '20140101' BETWEEN a.BeginDate AND a.EndDate 1 1 0 NULL NULL NULL NULL 81096,82 NULL NULL NULL 76,08408 NULL NULL SELECT 0 NULL
- 4616 1 |--Sequence Project(DEFINE:([Expr1008]=row_number)) 1 2 1 Sequence Project Compute Scalar DEFINE:([Expr1008]=row_number) [Expr1008]=row_number 81096,82 0 0,006487745 581 76,08408 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [c].[field1], [c].[field2], [c].[field3], [b].[field1], [Expr1008] NULL PLAN_ROW 0 1
- 4616 1 |--Segment 1 3 2 Segment Segment NULL NULL 81096,82 0 0,001621936 581 76,07759 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [c].[field1], [c].[field2], [c].[field3], [b].[field1], [Segment1015] NULL PLAN_ROW 0 1
- 4616 1 |--Parallelism(Gather Streams, ORDER BY:([c].[field2] ASC, [c].[field1] ASC)) 1 4 3 Parallelism Gather Streams ORDER BY:([c].[field2] ASC, [c].[field1] ASC) NULL 81096,82 0 2,216634 572 76,07597 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [c].[field1], [c].[field2], [c].[field3], [b].[field1] NULL PLAN_ROW 1 1
- 4616 4 |--Sort(ORDER BY:([c].[field2] ASC, [c].[field1] ASC)) 1 5 4 Sort Sort ORDER BY:([c].[field2] ASC, [c].[field1] ASC) NULL 81096,82 0,005630631 3,03513 572 73,85934 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [c].[field1], [c].[field2], [c].[field3], [b].[field1] NULL PLAN_ROW 1 1
- 4616 4 |--Nested Loops(Inner Join, OUTER REFERENCES:([Bmk1003], [Expr1014]) OPTIMIZED WITH UNORDERED PREFETCH) 1 6 5 Nested Loops Inner Join OUTER REFERENCES:([Bmk1003], [Expr1014]) OPTIMIZED WITH UNORDERED PREFETCH NULL 81096,82 0 0,1694923 572 70,81857 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [c].[field1], [c].[field2], [c].[field3], [b].[field1] NULL PLAN_ROW 1 1
- 0 0 |--Compute Scalar(DEFINE:([Expr1013]=BmkToPage([Bmk1003]))) 1 9 6 Compute Scalar Compute Scalar DEFINE:([Expr1013]=BmkToPage([Bmk1003])) [Expr1013]=BmkToPage([Bmk1003]) 81096,82 0 0,1694923 175 17,03391 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [Bmk1003], [b].[field1], [Expr1013] NULL PLAN_ROW 1 1
- 4616 4 | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1009], [Expr1012]) OPTIMIZED WITH UNORDERED PREFETCH) 1 10 9 Nested Loops Inner Join OUTER REFERENCES:([Expr1009], [Expr1012]) OPTIMIZED WITH UNORDERED PREFETCH NULL 81096,82 0 0,1694923 175 17,03391 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [Bmk1003], [b].[field1] NULL PLAN_ROW 1 1
- 4616 4 | |--Hash Match(Inner Join, HASH:([b].[t2_PKID])=([a].[t1_t2ID])) 1 13 10 Hash Match Inner Join HASH:([b].[t2_PKID])=([a].[t1_t2ID]) NULL 81096,82 0 0,3104207 175 1,060876 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [b].[field1], [Expr1009] NULL PLAN_ROW 1 1
- 116 4 | | |--Parallelism(Distribute Streams, Broadcast Partitioning) 1 14 13 Parallelism Distribute Streams NULL NULL 29 0 0,02883047 142 0,03214437 [b].[t2_PKID], [b].[field1] NULL PLAN_ROW 1 1
- 29 1 | | | |--Clustered Index Scan(OBJECT:([database_name].[dbo].[table2].[PK_table2] AS [b])) 1 15 14 Clustered Index Scan Clustered Index Scan OBJECT:([database_name].[dbo].[table2].[PK_table2] AS [b]) [b].[t2_PKID], [b].[field1] 29 0,003125 0,0001889 142 0,0033139 [b].[t2_PKID], [b].[field1] NULL PLAN_ROW 0 1
- 0 0 | | |--Compute Scalar(DEFINE:([Expr1009]=CONVERT_IMPLICIT(bigint,[database_name].[dbo].[table1].[p3_PKID] as [a].[t1_t3ID],0))) 1 16 13 Compute Scalar Compute Scalar DEFINE:([Expr1009]=CONVERT_IMPLICIT(bigint,[database_name].[dbo].[table1].[p3_PKID] as [a].[t1_t3ID],0)) [Expr1009]=CONVERT_IMPLICIT(bigint,[database_name].[dbo].[table1].[p3_PKID] as [a].[t1_t3ID],0) 82518,73 0 0,004125936 46 0,7183075 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate], [Expr1009] NULL PLAN_ROW 1 1
- 4616 4 | | |--Index Seek(OBJECT:([database_name].[dbo].[table1].[IDX_table1_Date] AS [a]), SEEK:([a].[BeginDate] <= '2014-01-01 00:00:00.000'), WHERE:([database_name].[dbo].[table1].[End_Date] as [a].[EndDate]>='2014-01-01 00:00:00.000') ORDERED FORWARD) 1 17 16 Index Seek Index Seek OBJECT:([database_name].[dbo].[table1].[IDX_table1_Date] AS [a]), SEEK:([a].[BeginDate] <= '2014-01-01 00:00:00.000'), WHERE:([database_name].[dbo].[table1].[End_Date] as [a].[EndDate]>='2014-01-01 00:00:00.000') ORDERED FORWARD [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate] 82518,73 0,5949768 0,08301447 38 0,6779913 [a].[t1_t3ID], [a].[t1_t2ID], [a].[BeginDate], [a].[EndDate] NULL PLAN_ROW 1 1
- 4616 4616 | |--Index Seek(OBJECT:([database_name].[dbo].[table3].[PK_table3] AS [p]), SEEK:([c].[p3_PKID]=[Expr1009]) ORDERED FORWARD) 1 22 10 Index Seek Index Seek OBJECT:([database_name].[dbo].[table3].[PK_table3] AS [p]), SEEK:([c].[p3_PKID]=[Expr1009]) ORDERED FORWARD [Bmk1003] 1 0,003125 0,0001581 15 15,80354 [Bmk1003] NULL PLAN_ROW 1 81096,82
- 4616 4616 |--RID Lookup(OBJECT:([database_name].[dbo].[table3] AS [p]), SEEK:([Bmk1003]=[Bmk1003]) LOOKUP ORDERED FORWARD) 1 27 6 RID Lookup RID Lookup OBJECT:([database_name].[dbo].[table3] AS [p]), SEEK:([Bmk1003]=[Bmk1003]) LOOKUP ORDERED FORWARD [c].[field1], [c].[field2], [c].[field3] 1 0,003125 0,0001581 414 53,61517 [c].[field1], [c].[field2], [c].[field3] NULL PLAN_ROW 1 81096,82
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
