Guest User

Query Execution Plan

a guest
Sep 29th, 2015
196
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×