Skip to content

Instantly share code, notes, and snippets.

@srogovtsev

srogovtsev/CROSS JOIN execution plan.xml

Created July 12, 2019 15:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save srogovtsev/6d4d83e1eaddb376ea3f3dc59de0e4a7 to your computer and use it in GitHub Desktop.
Save srogovtsev/6d4d83e1eaddb376ea3f3dc59de0e4a7 to your computer and use it in GitHub Desktop.
Download ZIP
INNER JOIN (OR) vs UNION
Raw
CROSS JOIN execution plan.xml
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.6" Build="14.0.2002.14" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1000" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="140" StatementSubTreeCost="3568.39" StatementText="SELECT TOP (1000) &#xD;&#xA; [Extent1].ID, &#xD;&#xA; [Extent1].[Name] AS [Name], &#xD;&#xA; [Extent2].[Name] AS [Name1]&#xD;&#xA; FROM [dbo].[Customer] AS [Extent1]&#xD;&#xA; CROSS JOIN [dbo].[Ref] AS [Extent2]&#xD;&#xA; WHERE [Extent1].[Ref_ID] = [Extent2].[ID] OR [Extent1].[Ref_ID2] = [Extent2].[ID2]" StatementType="SELECT" QueryHash="0x664E351C3880C4F6" QueryPlanHash="0xB5694E3EF22915FB" RetrievedFromCache="true" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="4" MemoryGrant="72" CachedPlanSize="32" CompileTime="3" CompileCPU="3" CompileMemory="216">
<ThreadStat Branches="1" UsedThreads="4">
<ThreadReservation NodeId="0" ReservedThreads="4" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" RequiredMemory="72" DesiredMemory="72" RequestedMemory="72" GrantWaitTime="0" GrantedMemory="72" MaxUsedMemory="72" MaxQueryMemory="1326816" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="520166" EstimatedPagesCached="130041" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="5431968" />
<WaitStats>
<Wait WaitType="PAGELATCH_SH" WaitTimeMs="11" WaitCount="2" />
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="18" WaitCount="1" />
<Wait WaitType="PAGELATCH_UP" WaitTimeMs="100" WaitCount="19" />
</WaitStats>
<QueryTimeStats CpuTime="1364368" ElapsedTime="401149" />
<RelOp AvgRowSize="527" EstimateCPU="0.0001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="3568.39">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="401118" ActualCPUms="0" />
</RunTimeInformation>
<Top RowCount="false" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(1000)">
<Const ConstValue="(1000)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="527" EstimateCPU="0.047741" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="3568.39">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="401118" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="527" EstimateCPU="30096000" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Inner Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3568.34">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="395" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="400760" ActualCPUms="353568" />
<RunTimeCountersPerThread Thread="3" ActualRows="373" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="401121" ActualCPUms="339829" />
<RunTimeCountersPerThread Thread="2" ActualRows="323" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="401073" ActualCPUms="301134" />
<RunTimeCountersPerThread Thread="1" ActualRows="409" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="400593" ActualCPUms="368897" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[Test].[dbo].[Customer].[Ref_ID] as [Extent1].[Ref_ID]=[Test].[dbo].[Ref].[ID] as [Extent2].[ID] OR [Test].[dbo].[Customer].[Ref_ID2] as [Extent1].[Ref_ID2]=[Test].[dbo].[Ref].[ID2] as [Extent2].[ID2]">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="278" EstimateCPU="6.60008" EstimateIO="51.8572" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" EstimatedRowsRead="12000000" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00807035" TableCardinality="12000000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="395" ActualRowsRead="395" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="1" ActualLogicalReads="5" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="373" ActualRowsRead="373" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="323" ActualRowsRead="323" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="409" ActualRowsRead="409" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="12" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" Alias="[Extent1]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="274" EstimateCPU="0.2161" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="1000" EstimatedExecutionMode="Row" EstimateRows="1200000" LogicalOp="Lazy Spool" NodeId="4" Parallel="true" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="223.057">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="394" ActualRows="473372948" ActualRowsRead="472172949" Batches="0" ActualEndOfScans="394" ActualExecutions="395" ActualExecutionMode="Row" ActualElapsedms="253083" ActualCPUms="248354" ActualScans="1" ActualLogicalReads="5815390" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="372" ActualRows="446417163" ActualRowsRead="445217166" Batches="0" ActualEndOfScans="372" ActualExecutions="373" ActualExecutionMode="Row" ActualElapsedms="244763" ActualCPUms="238451" ActualScans="1" ActualLogicalReads="5684663" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="322" ActualRows="386475567" ActualRowsRead="385275570" Batches="0" ActualEndOfScans="322" ActualExecutions="323" ActualExecutionMode="Row" ActualElapsedms="225564" ActualCPUms="211904" ActualScans="1" ActualLogicalReads="5393881" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="408" ActualRows="490496499" ActualRowsRead="489296502" Batches="0" ActualEndOfScans="408" ActualExecutions="409" ActualExecutionMode="Row" ActualElapsedms="262258" ActualCPUms="259676" ActualScans="1" ActualLogicalReads="5898447" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<Spool>
<RelOp AvgRowSize="274" EstimateCPU="1.32016" EstimateIO="5.41053" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" EstimatedRowsRead="1200000" LogicalOp="Clustered Index Scan" NodeId="5" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.73069" TableCardinality="1200000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="1199999" ActualRowsRead="1199999" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="521" ActualCPUms="512" ActualScans="1" ActualLogicalReads="7316" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="1199999" ActualRowsRead="1199999" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="513" ActualCPUms="512" ActualScans="1" ActualLogicalReads="7316" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="1199999" ActualRowsRead="1199999" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="521" ActualCPUms="491" ActualScans="1" ActualLogicalReads="7316" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="1199999" ActualRowsRead="1199999" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="569" ActualCPUms="560" ActualScans="1" ActualLogicalReads="7316" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Ref]" Index="[PK_Ref]" Alias="[Extent2]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Spool>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</Top>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Raw
DISTINCT CROSS JOIN execution plan.xml
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.6" Build="14.0.2002.14" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1000" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="140" StatementSubTreeCost="3568.51" StatementText="SELECT &#xD;&#xA; [Limit1].[C1] AS [C1], &#xD;&#xA; [Limit1].[Name] AS [Name], &#xD;&#xA; [Limit1].[Name1] AS [Name1]&#xD;&#xA; FROM ( SELECT DISTINCT TOP (1000) &#xD;&#xA; [Extent1].[Name] AS [Name], &#xD;&#xA; [Extent2].[Name] AS [Name1], &#xD;&#xA; 1 AS [C1]&#xD;&#xA; FROM [dbo].[Customer] AS [Extent1]&#xD;&#xA; CROSS JOIN [dbo].[Ref] AS [Extent2]&#xD;&#xA; WHERE [Extent1].[Ref_ID] = [Extent2].[ID] OR [Extent1].[Ref_ID2] = [Extent2].[ID2]&#xD;&#xA; ) AS [Limit1]" StatementType="SELECT" QueryHash="0xA879DCBAC9C31CE1" QueryPlanHash="0x2F6323A95F87EC41" RetrievedFromCache="true" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="4" MemoryGrant="4680" CachedPlanSize="48" CompileTime="15" CompileCPU="15" CompileMemory="488">
<ThreadStat Branches="2" UsedThreads="8">
<ThreadReservation NodeId="0" ReservedThreads="8" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1232" RequiredMemory="4456" DesiredMemory="4680" RequestedMemory="4680" GrantWaitTime="0" GrantedMemory="4680" MaxUsedMemory="1720" MaxQueryMemory="1459368" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="520166" EstimatedPagesCached="130041" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="5666792" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000005_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:01.14" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000002_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:01.47" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000003_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:00.92" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Ref]" Statistics="[PK_Ref]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-07-12T16:49:00.74" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Ref]" Statistics="[_WA_Sys_00000003_35BCFE0A]" ModificationCount="0" SamplingPercent="19.4271" LastUpdate="2019-07-12T15:51:05.87" />
</OptimizerStatsUsage>
<WaitStats>
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="3" WaitCount="206" />
<Wait WaitType="LATCH_EX" WaitTimeMs="55" WaitCount="3" />
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="149" WaitCount="279" />
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="342" WaitCount="1" />
</WaitStats>
<QueryTimeStats CpuTime="1413" ElapsedTime="438" />
<RelOp AvgRowSize="43" EstimateCPU="0.0001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="3568.51">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Column="Expr1002" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94" ActualCPUms="0" />
</RunTimeInformation>
<Top RowCount="false" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(1000)">
<Const ConstValue="(1000)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="43" EstimateCPU="0.0310263" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="3568.51">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Column="Expr1002" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="43" EstimateCPU="2212.36" EstimateIO="2466.84" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Flow Distinct" NodeId="2" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="3568.48">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Column="Expr1002" />
</OutputList>
<MemoryFractions Input="0" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="606" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="133" ActualCPUms="4" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1024" OutputMemoryGrant="1080" UsedMemoryGrant="352" />
<RunTimeCountersPerThread Thread="3" ActualRows="608" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="122" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1024" OutputMemoryGrant="1080" UsedMemoryGrant="344" />
<RunTimeCountersPerThread Thread="2" ActualRows="607" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="135" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1024" OutputMemoryGrant="1080" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="1" ActualRows="607" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="132" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1024" OutputMemoryGrant="1080" UsedMemoryGrant="344" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Hash>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="ANY([Expr1002])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1002" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</HashKeysBuild>
<BuildResidual>
<ScalarOperator ScalarString="[Test].[dbo].[Customer].[Name] as [Extent1].[Name] = [Test].[dbo].[Customer].[Name] as [Extent1].[Name] AND [Test].[dbo].[Ref].[Name] as [Extent2].[Name] = [Test].[dbo].[Ref].[Name] as [Extent2].[Name]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</BuildResidual>
<RelOp AvgRowSize="43" EstimateCPU="0.6" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Compute Scalar" NodeId="3" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="3568.07">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Column="Expr1002" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="39" EstimateCPU="0.0435447" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Repartition Streams" NodeId="4" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="3568.07">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="606" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="111" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="608" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="121" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="607" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="134" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="607" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="131" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</PartitionColumns>
<RelOp AvgRowSize="39" EstimateCPU="30096000" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3568.03">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="316" ActualCPUms="257" />
<RunTimeCountersPerThread Thread="1" ActualRows="8107" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="273" ActualCPUms="236" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[Test].[dbo].[Customer].[Ref_ID] as [Extent1].[Ref_ID]=[Test].[dbo].[Ref].[ID] as [Extent2].[ID] OR [Test].[dbo].[Customer].[Ref_ID2] as [Extent1].[Ref_ID2]=[Test].[dbo].[Ref].[ID2] as [Extent2].[ID2]">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="31" EstimateCPU="0.660078" EstimateIO="5.41053" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="99.9999" EstimatedRowsRead="1200000" LogicalOp="Clustered Index Scan" NodeId="6" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00370461" TableCardinality="1200000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="50" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Ref]" Index="[PK_Ref]" Alias="[Extent2]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="33" EstimateCPU="2.1601" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="99.9998" EstimatedExecutionMode="Row" EstimateRows="12000000" LogicalOp="Lazy Spool" NodeId="7" Parallel="true" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="283.237">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="43418" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="402" ActualCPUms="344" ActualScans="0" ActualLogicalReads="87816" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="42903" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="414" ActualCPUms="391" ActualScans="0" ActualLogicalReads="86773" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="45126" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="370" ActualCPUms="362" ActualScans="0" ActualLogicalReads="91273" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="24318" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="246" ActualCPUms="210" ActualScans="0" ActualLogicalReads="49176" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<Spool>
<RelOp AvgRowSize="33" EstimateCPU="13.2002" EstimateIO="51.8572" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" EstimatedRowsRead="12000000" LogicalOp="Clustered Index Scan" NodeId="8" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="65.0574" TableCardinality="12000000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="43419" ActualRowsRead="43419" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="22" ActualCPUms="22" ActualScans="1" ActualLogicalReads="251" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="42904" ActualRowsRead="42904" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="63" ActualCPUms="63" ActualScans="1" ActualLogicalReads="248" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="45126" ActualRowsRead="45127" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="26" ActualCPUms="26" ActualScans="1" ActualLogicalReads="260" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="24318" ActualRowsRead="24318" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12" ActualCPUms="12" ActualScans="1" ActualLogicalReads="149" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID2" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" Alias="[Extent1]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Spool>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Top>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Raw
UNION execution plan.xml
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.6" Build="14.0.2002.14" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1000" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="140" StatementSubTreeCost="1597.19" StatementText="SELECT &#xD;&#xA; [Limit1].[C1] AS [C1], &#xD;&#xA; [Limit1].[C2] AS [C2], &#xD;&#xA; [Limit1].[C3] AS [C3]&#xD;&#xA; FROM ( SELECT DISTINCT TOP (1000) &#xD;&#xA; [UnionAll1].[C1] AS [C1], &#xD;&#xA; [UnionAll1].[Name] AS [C2], &#xD;&#xA; [UnionAll1].[Name1] AS [C3]&#xD;&#xA; FROM (SELECT &#xD;&#xA; 1 AS [C1], &#xD;&#xA; [Extent1].[Name] AS [Name], &#xD;&#xA; [Extent2].[Name] AS [Name1]&#xD;&#xA; FROM [dbo].[Customer] AS [Extent1]&#xD;&#xA; INNER JOIN [dbo].[Ref] AS [Extent2] ON [Extent1].[Ref_ID] = [Extent2].[ID]&#xD;&#xA; UNION ALL&#xD;&#xA; SELECT &#xD;&#xA; 1 AS [C1], &#xD;&#xA; [Extent3].[Name] AS [Name], &#xD;&#xA; [Extent4].[Name] AS [Name1]&#xD;&#xA; FROM [dbo].[Customer] AS [Extent3]&#xD;&#xA; INNER JOIN [dbo].[Ref] AS [Extent4] ON [Extent3].[Ref_ID2] = [Extent4].[ID2]) AS [UnionAll1]&#xD;&#xA; ) AS [Limit1]" StatementType="SELECT" QueryHash="0x47CCEF9E5A9A536F" QueryPlanHash="0xD233E19D6B8A567A" RetrievedFromCache="true" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="4" MemoryGrant="1467688" CachedPlanSize="104" CompileTime="95" CompileCPU="95" CompileMemory="1040">
<ThreadStat Branches="2" UsedThreads="8">
<ThreadReservation NodeId="0" ReservedThreads="8" />
</ThreadStat>
<MissingIndexes>
<MissingIndexGroup Impact="19.0427">
<MissingIndex Database="[Test]" Schema="[dbo]" Table="[Customer]">
<ColumnGroup Usage="EQUALITY">
<Column Name="[Ref_ID2]" ColumnId="5" />
</ColumnGroup>
<ColumnGroup Usage="INCLUDE">
<Column Name="[Name]" ColumnId="2" />
</ColumnGroup>
</MissingIndex>
</MissingIndexGroup>
<MissingIndexGroup Impact="12.5426">
<MissingIndex Database="[Test]" Schema="[dbo]" Table="[Customer]">
<ColumnGroup Usage="EQUALITY">
<Column Name="[Ref_ID]" ColumnId="3" />
</ColumnGroup>
<ColumnGroup Usage="INCLUDE">
<Column Name="[Name]" ColumnId="2" />
</ColumnGroup>
</MissingIndex>
</MissingIndexGroup>
</MissingIndexes>
<MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="3208336" RequiredMemory="8904" DesiredMemory="3215720" RequestedMemory="1467688" GrantWaitTime="0" GrantedMemory="1467688" MaxUsedMemory="566432" MaxQueryMemory="1430896" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="520166" EstimatedPagesCached="130041" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="5133400" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000005_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:01.14" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000002_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:01.47" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Ref]" Statistics="[PK_Ref]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-07-12T16:49:00.74" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Customer]" Statistics="[_WA_Sys_00000003_38996AB5]" ModificationCount="0" SamplingPercent="2.39173" LastUpdate="2019-07-12T15:51:00.92" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Ref]" Statistics="[_WA_Sys_00000002_35BCFE0A]" ModificationCount="0" SamplingPercent="19.7853" LastUpdate="2019-07-12T15:51:05.42" />
<StatisticsInfo Database="[Test]" Schema="[dbo]" Table="[Ref]" Statistics="[_WA_Sys_00000003_35BCFE0A]" ModificationCount="0" SamplingPercent="19.4271" LastUpdate="2019-07-12T15:51:05.87" />
</OptimizerStatsUsage>
<WaitStats>
<Wait WaitType="LATCH_EX" WaitTimeMs="1" WaitCount="6" />
<Wait WaitType="PAGELATCH_UP" WaitTimeMs="8" WaitCount="2" />
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="54" WaitCount="2" />
<Wait WaitType="IO_COMPLETION" WaitTimeMs="146" WaitCount="16" />
</WaitStats>
<QueryTimeStats CpuTime="155753" ElapsedTime="174659" />
<RelOp AvgRowSize="43" EstimateCPU="0.0001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="1597.19">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174602" ActualCPUms="0" />
</RunTimeInformation>
<Top RowCount="false" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(1000)">
<Const ConstValue="(1000)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="43" EstimateCPU="0.0310263" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1597.19">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174602" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="43" EstimateCPU="8.04956" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Aggregate" NodeId="2" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1597.16">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="491" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="114" ActualCPUms="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="491" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="102" ActualCPUms="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="491" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="102" ActualCPUms="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="655" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="116" ActualCPUms="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="174510" ActualCPUms="0" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1006" />
<ScalarOperator ScalarString="ANY([Union1006])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1006" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Column="Union1008" />
<ColumnReference Column="Union1007" />
</GroupBy>
<RelOp AvgRowSize="43" EstimateCPU="0.0489986" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1003.39" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1597.16">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="492" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="113" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="492" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="101" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="492" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="101" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="656" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="115" ActualCPUms="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="174510" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Column="Union1008" />
<ColumnReference Column="Union1007" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Column="Union1008" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Union1007" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="43" EstimateCPU="8.06923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1003.39" LogicalOp="Aggregate" NodeId="4" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1597.11">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="2076" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174155" ActualCPUms="37583" />
<RunTimeCountersPerThread Thread="3" ActualRows="1564" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174022" ActualCPUms="21454" />
<RunTimeCountersPerThread Thread="2" ActualRows="2551" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174512" ActualCPUms="73806" />
<RunTimeCountersPerThread Thread="1" ActualRows="2113" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="173860" ActualCPUms="6454" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1006" />
<ScalarOperator ScalarString="ANY([Union1006])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1006" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Column="Union1008" />
<ColumnReference Column="Union1007" />
</GroupBy>
<RelOp AvgRowSize="43" EstimateCPU="294.911" EstimateIO="783.953" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1004.89" LogicalOp="Sort" NodeId="5" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="1597.11">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<Warnings>
<SpillToTempDb SpillLevel="1" SpilledThreadCount="4" />
<SortSpillDetails GrantedMemoryKb="747808" UsedMemoryKb="482552" WritesToTempDb="107509" ReadsFromTempDb="107509" />
</Warnings>
<MemoryFractions Input="0.511241" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="4149" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174150" ActualCPUms="37578" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="681" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="186952" OutputMemoryGrant="364824" UsedMemoryGrant="125808" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="3129" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174019" ActualCPUms="21451" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="590" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="186952" OutputMemoryGrant="364824" UsedMemoryGrant="96896" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="5103" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="174506" ActualCPUms="73800" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="811" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="186952" OutputMemoryGrant="364824" UsedMemoryGrant="186952" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="4227" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="173855" ActualCPUms="6450" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="758" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="186952" OutputMemoryGrant="364824" UsedMemoryGrant="72896" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Column="Union1008" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Union1007" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="43" EstimateCPU="0.807528" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16150600" LogicalOp="Concatenation" NodeId="6" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="518.245">
<OutputList>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Union1007" />
<ColumnReference Column="Union1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="6451136" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="127817" ActualCPUms="5066" />
<RunTimeCountersPerThread Thread="3" ActualRows="3906432" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="148832" ActualCPUms="3588" />
<RunTimeCountersPerThread Thread="2" ActualRows="11857538" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="63153" ActualCPUms="7984" />
<RunTimeCountersPerThread Thread="1" ActualRows="1784894" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="167568" ActualCPUms="2330" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1006" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1005" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1007" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1008" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="43" EstimateCPU="0.6" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" LogicalOp="Compute Scalar" NodeId="7" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="207.004">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
<ColumnReference Column="Expr1002" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="39" EstimateCPU="114.702" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="206.404">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<MemoryFractions Input="1" Output="0.488759" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3225568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="55650" ActualCPUms="1903" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="365720" OutputMemoryGrant="179272" UsedMemoryGrant="19944" />
<RunTimeCountersPerThread Thread="3" ActualRows="1953216" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="65433" ActualCPUms="1404" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="365720" OutputMemoryGrant="179272" UsedMemoryGrant="19872" />
<RunTimeCountersPerThread Thread="2" ActualRows="5928769" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="25369" ActualCPUms="2909" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="365720" OutputMemoryGrant="179272" UsedMemoryGrant="19920" />
<RunTimeCountersPerThread Thread="1" ActualRows="892447" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="73845" ActualCPUms="976" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="365720" OutputMemoryGrant="179272" UsedMemoryGrant="19880" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</HashKeysProbe>
<RelOp AvgRowSize="27" EstimateCPU="2.41845" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="8.48906">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="315" ActualCPUms="25" />
<RunTimeCountersPerThread Thread="3" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="367" ActualCPUms="25" />
<RunTimeCountersPerThread Thread="2" ActualRows="300002" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="318" ActualCPUms="28" />
<RunTimeCountersPerThread Thread="1" ActualRows="299997" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="321" ActualCPUms="26" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</PartitionColumns>
<RelOp AvgRowSize="27" EstimateCPU="0.660078" EstimateIO="5.41053" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" EstimatedRowsRead="1200000" LogicalOp="Clustered Index Scan" NodeId="10" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.07061" TableCardinality="1200000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="297534" ActualRowsRead="297534" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="100" ActualCPUms="90" ActualScans="1" ActualLogicalReads="1796" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="303536" ActualRowsRead="303536" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="89" ActualCPUms="89" ActualScans="1" ActualLogicalReads="1881" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="295393" ActualRowsRead="295393" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="93" ActualCPUms="93" ActualScans="1" ActualLogicalReads="1806" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="303536" ActualRowsRead="303536" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="90" ActualCPUms="90" ActualScans="1" ActualLogicalReads="1881" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent2]" Column="Name" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Ref]" Index="[PK_Ref]" Alias="[Extent2]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="29" EstimateCPU="24.756" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="83.2133">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3225568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="51159" ActualCPUms="364" />
<RunTimeCountersPerThread Thread="3" ActualRows="1953216" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="63074" ActualCPUms="230" />
<RunTimeCountersPerThread Thread="2" ActualRows="5928769" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="8476" ActualCPUms="647" />
<RunTimeCountersPerThread Thread="1" ActualRows="892447" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="72557" ActualCPUms="115" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</PartitionColumns>
<RelOp AvgRowSize="29" EstimateCPU="6.60008" EstimateIO="51.8572" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" EstimatedRowsRead="12000000" LogicalOp="Clustered Index Scan" NodeId="12" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="58.4573" TableCardinality="12000000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3324062" ActualRowsRead="3324062" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1005" ActualCPUms="1005" ActualScans="1" ActualLogicalReads="19745" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="3596963" ActualRowsRead="3596963" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1067" ActualCPUms="1066" ActualScans="1" ActualLogicalReads="21320" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="1149168" ActualRowsRead="1149168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="366" ActualCPUms="365" ActualScans="1" ActualLogicalReads="6834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="3929807" ActualRowsRead="3929807" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1198" ActualCPUms="1179" ActualScans="1" ActualLogicalReads="23210" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent1]" Column="Ref_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" Alias="[Extent1]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="527" EstimateCPU="0.207528" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4150570" LogicalOp="Compute Scalar" NodeId="13" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="310.433">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
<ColumnReference Column="Expr1005" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1005" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="523" EstimateCPU="108.689" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4150570" LogicalOp="Inner Join" NodeId="14" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="310.226">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</OutputList>
<MemoryFractions Input="0.488759" Output="0.488759" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3225568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="71382" ActualCPUms="2378" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="179272" OutputMemoryGrant="179272" UsedMemoryGrant="19944" />
<RunTimeCountersPerThread Thread="3" ActualRows="1953216" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="82928" ActualCPUms="1713" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="179272" OutputMemoryGrant="179272" UsedMemoryGrant="19872" />
<RunTimeCountersPerThread Thread="2" ActualRows="5928769" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="36354" ActualCPUms="3645" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="179272" OutputMemoryGrant="179272" UsedMemoryGrant="19920" />
<RunTimeCountersPerThread Thread="1" ActualRows="892447" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="93494" ActualCPUms="1124" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="179272" OutputMemoryGrant="179272" UsedMemoryGrant="19880" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</HashKeysProbe>
<RelOp AvgRowSize="270" EstimateCPU="12.4786" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" LogicalOp="Bitmap Create" NodeId="15" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="18.5492">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="534" ActualCPUms="111" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="1024" />
<RunTimeCountersPerThread Thread="3" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="497" ActualCPUms="108" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="1024" />
<RunTimeCountersPerThread Thread="2" ActualRows="300002" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="470" ActualCPUms="103" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="1024" />
<RunTimeCountersPerThread Thread="1" ActualRows="299997" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="540" ActualCPUms="110" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="1024" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1009" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
</HashKeys>
<RelOp AvgRowSize="270" EstimateCPU="12.4786" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" LogicalOp="Repartition Streams" NodeId="16" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="18.5492">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="452" ActualCPUms="28" />
<RunTimeCountersPerThread Thread="3" ActualRows="300000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="417" ActualCPUms="28" />
<RunTimeCountersPerThread Thread="2" ActualRows="300002" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="392" ActualCPUms="25" />
<RunTimeCountersPerThread Thread="1" ActualRows="299997" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="459" ActualCPUms="29" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
</PartitionColumns>
<RelOp AvgRowSize="270" EstimateCPU="0.660078" EstimateIO="5.41053" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1200000" EstimatedRowsRead="1200000" LogicalOp="Clustered Index Scan" NodeId="17" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.07061" TableCardinality="1200000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="293040" ActualRowsRead="293040" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="80" ActualCPUms="80" ActualScans="1" ActualLogicalReads="1796" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="295393" ActualRowsRead="295393" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="85" ActualCPUms="85" ActualScans="1" ActualLogicalReads="1806" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="303536" ActualRowsRead="303536" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="84" ActualCPUms="84" ActualScans="1" ActualLogicalReads="1881" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="308030" ActualRowsRead="308030" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="107" ActualCPUms="86" ActualScans="1" ActualLogicalReads="1881" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="ID2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Ref]" Alias="[Extent4]" Column="Name" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Ref]" Index="[PK_Ref]" Alias="[Extent4]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
<RelOp AvgRowSize="270" EstimateCPU="124.53" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" LogicalOp="Repartition Streams" NodeId="18" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="182.987">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3225568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="64746" ActualCPUms="410" />
<RunTimeCountersPerThread Thread="3" ActualRows="1953216" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="79603" ActualCPUms="245" />
<RunTimeCountersPerThread Thread="2" ActualRows="5928769" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="10027" ActualCPUms="657" />
<RunTimeCountersPerThread Thread="1" ActualRows="892447" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="91859" ActualCPUms="126" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</PartitionColumns>
<RelOp AvgRowSize="270" EstimateCPU="6.60008" EstimateIO="51.8572" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12000000" EstimatedRowsRead="12000000" LogicalOp="Clustered Index Scan" NodeId="19" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="58.4573" TableCardinality="12000000">
<OutputList>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3604389" ActualRowsRead="3604389" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1647" ActualCPUms="1561" ActualScans="1" ActualLogicalReads="21429" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="3599305" ActualRowsRead="3599305" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1586" ActualCPUms="1538" ActualScans="1" ActualLogicalReads="21372" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="1382725" ActualRowsRead="1382725" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="590" ActualCPUms="590" ActualScans="1" ActualLogicalReads="8220" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="3413581" ActualRowsRead="3413581" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1540" ActualCPUms="1454" ActualScans="1" ActualLogicalReads="20276" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</DefinedValue>
</DefinedValues>
<Object Database="[Test]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" Alias="[Extent3]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1009],[Test].[dbo].[Customer].[Ref_ID2] as [Extent3].[Ref_ID2],N'[IN ROW]')">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1009" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Test]" Schema="[dbo]" Table="[Customer]" Alias="[Extent3]" Column="Ref_ID2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'[IN ROW]'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
</Top>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment