(60387 row(s) affected) (60387 row(s) affected) (60387 row(s) affected) (60387 row(s) affected) (7558 row(s) affected) (7558 row(s) affected) (7558 row(s) affected) (7558 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions -------------------- -------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------------------------------ ------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------- --------------------- ------------- ------------- ------------- ----------- ---------------- ----------------------------------------- -------- ---------------------------------------------------------------- -------- ------------------ 1158 1 INSERT INTO @BitBucket3(word) SELECT WordsUsed.word FROM @UniqueWords WordsUsed LEFT OUTER JOIN @WordsWithUniqueConstraint commonwords ON commonWords.word=WordsUsed.word WHERE commonWords.word IS null 1 1 0 NULL NULL NULL NULL 1 NULL NULL NULL 0.01657196 NULL NULL INSERT 0 NULL 1158 1 |--Table Insert(OBJECT:(@BitBucket3), SET:([Word] = @UniqueWords.[Word] as [WordsUsed].[Word])) 1 2 1 Table Insert Insert OBJECT:(@BitBucket3), SET:([Word] = @UniqueWords.[Word] as [WordsUsed].[Word]) NULL 1 0.01 1E-06 9 0.01657196 NULL NULL PLAN_ROW 0 1 1158 1 |--Top(ROWCOUNT est 0) 1 3 2 Top Top TOP EXPRESSION:((0)) NULL 1 0 1E-07 51 0.00657096 [WordsUsed].[Word] NULL PLAN_ROW 0 1 1158 1 |--Filter(WHERE:(@WordsWithUniqueConstraint.[Word] as [commonwords].[Word] IS NULL)) 1 4 3 Filter Filter WHERE:(@WordsWithUniqueConstraint.[Word] as [commonwords].[Word] IS NULL) NULL 1 0 4.8E-07 51 0.00657086 [WordsUsed].[Word] NULL PLAN_ROW 0 1 7558 1 |--Nested Loops(Left Outer Join, OUTER REFERENCES:([WordsUsed].[Word])) 1 5 4 Nested Loops Left Outer Join OUTER REFERENCES:([WordsUsed].[Word]) NULL 1 0 4.18E-06 73 0.00657038 [WordsUsed].[Word], [commonwords].[Word] NULL PLAN_ROW 0 1 7558 1 |--Index Scan(OBJECT:(@UniqueWords AS [WordsUsed])) 1 6 5 Index Scan Index Scan OBJECT:(@UniqueWords AS [WordsUsed]) [WordsUsed].[Word] 1 0.003125 0.0001581 51 0.0032831 [WordsUsed].[Word] NULL PLAN_ROW 0 1 6400 7558 |--Index Seek(OBJECT:(@WordsWithUniqueConstraint AS [commonwords]), SEEK:([commonwords].[Word]=@UniqueWords.[Word] as [WordsUsed].[Word]) ORDERED FORWARD) 1 7 5 Index Seek Index Seek OBJECT:(@WordsWithUniqueConstraint AS [commonwords]), SEEK:([commonwords].[Word]=@UniqueWords.[Word] as [WordsUsed].[Word]) ORDERED FORWARD [commonwords].[Word] 1 0.003125 0.0001581 31 0.0032831 [commonwords].[Word] NULL PLAN_ROW 0 1 (7 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions -------------------- -------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------- ----------- ----------- ------------------------------ ------------------------------ --------------------------------------------------------------------------------------------------- --------------------- ------------- ------------- ------------- ----------- ---------------- ----------------------------------------- -------- ---------------------------------------------------------------- -------- ------------------ 1158 1 INSERT INTO @BitBucket7(word) SELECT WordsUsed.word FROM @UnindexedWords WordsUsed LEFT OUTER JOIN @WordsWithNoPK commonwords ON commonWords.word=WordsUsed.word WHERE commonWords.word IS null 2 1 0 NULL NULL NULL NULL 1 NULL NULL NULL 0.01657226 NULL NULL INSERT 0 NULL 1158 1 |--Table Insert(OBJECT:(@BitBucket7), SET:([Word] = @UnindexedWords.[Word] as [WordsUsed].[Word])) 2 2 1 Table Insert Insert OBJECT:(@BitBucket7), SET:([Word] = @UnindexedWords.[Word] as [WordsUsed].[Word]) NULL 1 0.01 1E-06 9 0.01657226 NULL NULL PLAN_ROW 0 1 1158 1 |--Top(ROWCOUNT est 0) 2 3 2 Top Top TOP EXPRESSION:((0)) NULL 1 0 1E-07 51 0.00657126 [WordsUsed].[Word] NULL PLAN_ROW 0 1 1158 1 |--Filter(WHERE:(@WordsWithNoPK.[Word] as [commonwords].[Word] IS NULL)) 2 4 3 Filter Filter WHERE:(@WordsWithNoPK.[Word] as [commonwords].[Word] IS NULL) NULL 1 0 4.8E-07 51 0.00657116 [WordsUsed].[Word] NULL PLAN_ROW 0 1 7558 1 |--Nested Loops(Left Outer Join, WHERE:(@WordsWithNoPK.[Word] as [commonwords].[Word]=@UnindexedWords.[Word] as [WordsUsed].[Word])) 2 5 4 Nested Loops Left Outer Join WHERE:(@WordsWithNoPK.[Word] as [commonwords].[Word]=@UnindexedWords.[Word] as [WordsUsed].[Word]) NULL 1 0 4.18E-06 73 0.00657068 [WordsUsed].[Word], [commonwords].[Word] NULL PLAN_ROW 0 1 7558 1 |--Table Scan(OBJECT:(@UnindexedWords AS [WordsUsed])) 2 6 5 Table Scan Table Scan OBJECT:(@UnindexedWords AS [WordsUsed]) [WordsUsed].[Word] 1 0.003125 0.0001581 51 0.0032831 [WordsUsed].[Word] NULL PLAN_ROW 0 1 456404946 7558 |--Table Scan(OBJECT:(@WordsWithNoPK AS [commonwords])) 2 7 5 Table Scan Table Scan OBJECT:(@WordsWithNoPK AS [commonwords]) [commonwords].[Word] 1 0.003125 0.0001581 31 0.0032831 [commonwords].[Word] NULL PLAN_ROW 0 1 (7 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. (1 row(s) affected) (1158 row(s) affected) (1 row(s) affected) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- both PK both TVs took 33 Ms. one PK both TVs took 46 Ms. Both Unique both TVs took 36 Ms. no PK both TVs took 116383 Ms. no PK both TVs-recompile took 76 Ms. both PK one TV one TT took 113 Ms. both PK both TT took 56 Ms. (7 row(s) affected)