Skip to content

Instantly share code, notes, and snippets.

@jtheisen
Created August 22, 2016 10:34
Show Gist options
  • Save jtheisen/8da704a10fcce8fbba152489507ddc73 to your computer and use it in GitHub Desktop.
Save jtheisen/8da704a10fcce8fbba152489507ddc73 to your computer and use it in GitHub Desktop.
<?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.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="241.548" StatementText="SELECT TOP 1&#xD;&#xA; [Project1].[C1] AS [C1], &#xD;&#xA; [Project1].[Id] AS [Id], &#xD;&#xA; [Project1].[SupplierNumber] AS [SupplierNumber], &#xD;&#xA; [Project1].[ArticleNumber] AS [ArticleNumber], &#xD;&#xA; [Project1].[ArticleName] AS [ArticleName]&#xD;&#xA; FROM ( SELECT &#xD;&#xA; [Extent1].[SupplierNumber] AS [SupplierNumber], &#xD;&#xA; [Extent1].[ArticleNumber] AS [ArticleNumber], &#xD;&#xA; [Extent1].[Id] AS [Id], &#xD;&#xA; [Extent1].[ArticleName] AS [ArticleName], &#xD;&#xA; 1 AS [C1]&#xD;&#xA; FROM [dbo].[SalesEntry] AS [Extent1]&#xD;&#xA; LEFT OUTER JOIN [dbo].[Article] AS [Extent2] ON ([Extent1].[ArticleNumber] = [Extent2].[ArticleNumber]) AND ([Extent1].[SupplierNumber] = [Extent2].[SupplierNumber])&#xD;&#xA; WHERE [Extent2].[id] IS NULL&#xD;&#xA; ) AS [Project1]&#xD;&#xA; ORDER BY [Project1].[SupplierNumber] ASC, [Project1].[ArticleNumber] ASC" StatementType="SELECT" QueryHash="0x5289781A9AC2B0B8" QueryPlanHash="0xFC5FD4ADD2E68506" RetrievedFromCache="true">
<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="16" MemoryGrant="986248" CachedPlanSize="64" CompileTime="6" CompileCPU="6" CompileMemory="528">
<ThreadStat Branches="2" UsedThreads="32">
<ThreadReservation NodeId="0" ReservedThreads="4" />
<ThreadReservation NodeId="1" ReservedThreads="4" />
<ThreadReservation NodeId="2" ReservedThreads="4" />
<ThreadReservation NodeId="3" ReservedThreads="4" />
<ThreadReservation NodeId="4" ReservedThreads="4" />
<ThreadReservation NodeId="5" ReservedThreads="4" />
<ThreadReservation NodeId="6" ReservedThreads="4" />
<ThreadReservation NodeId="7" ReservedThreads="4" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="1040" SerialDesiredMemory="961896" RequiredMemory="25352" DesiredMemory="986248" RequestedMemory="986248" GrantWaitTime="0" GrantedMemory="986248" MaxUsedMemory="57976" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209712" EstimatedPagesCached="209712" EstimatedAvailableDegreeOfParallelism="8" />
<RelOp AvgRowSize="1075" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="241.548">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
<ColumnReference Column="Expr1002" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1071" EstimateCPU="0.000101071" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="TopN Sort" NodeId="1" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="241.548">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</OutputList>
<MemoryFractions Input="8.32591E-06" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TopSort Distinct="false" Rows="1">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="1071" EstimateCPU="0.0285765" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Gather Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="241.537">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1364728" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="1071" EstimateCPU="0.188063" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="3" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="241.508">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="12" ActualRows="74665" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="16" ActualRows="73911" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="77132" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="74533" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="75050" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="75564" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="76075" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="80613" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="79294" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="75404" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="124413" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="75505" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="76572" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="123324" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="126544" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="76129" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="1075" EstimateCPU="32.6711" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3134390" LogicalOp="Right Outer Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="241.32">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
</OutputList>
<MemoryFractions Input="1" Output="0.999992" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="12" ActualRows="183502" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="16" ActualRows="186820" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="184512" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="181485" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="187612" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="194768" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="183771" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="191363" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="192696" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="187083" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="232582" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="187913" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="187314" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="234379" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="234688" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="183899" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Column="Expr1003" />
<ColumnReference Column="Expr1004" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[DataBase].[dbo].[SalesEntry].[ArticleNumber] as [Extent1].[ArticleNumber]=[Expr1003] AND [DataBase].[dbo].[SalesEntry].[SupplierNumber] as [Extent1].[SupplierNumber]=[Expr1004]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1003" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1004" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="284" EstimateCPU="3.5426" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="592506" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="5.33091">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
<ColumnReference Column="Expr1003" />
<ColumnReference Column="Expr1004" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="12" ActualRows="37124" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="16" ActualRows="37157" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="36580" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="36929" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="37119" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="36804" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="37073" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="37267" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="36589" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="36959" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="37041" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="36819" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="37039" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="37359" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="37455" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="37192" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Column="Expr1003" />
<ColumnReference Column="Expr1004" />
</PartitionColumns>
<RelOp AvgRowSize="284" EstimateCPU="0.00740633" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="592506" LogicalOp="Compute Scalar" NodeId="6" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.78832">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
<ColumnReference Column="Expr1003" />
<ColumnReference Column="Expr1004" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(255),[DataBase].[dbo].[Article].[ArticleNumber] as [Extent2].[ArticleNumber],0)">
<Convert DataType="nvarchar" Length="510" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="ArticleNumber" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(255),[DataBase].[dbo].[Article].[SupplierNumber] as [Extent2].[SupplierNumber],0)">
<Convert DataType="nvarchar" Length="510" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="SupplierNumber" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="150" EstimateCPU="0.0814892" EstimateIO="1.69942" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="592506" LogicalOp="Index Scan" NodeId="7" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.78091" TableCardinality="592506">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="ArticleNumber" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="33428" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="24311" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="47146" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="40435" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="25070" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="50020" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="37256" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="16" ActualRows="39331" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="41057" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="12" ActualRows="24445" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="25215" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="49381" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="55423" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="32866" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="42109" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="25013" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="SupplierNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="ArticleNumber" />
</DefinedValue>
</DefinedValues>
<Object Database="[DataBase]" Schema="[dbo]" Table="[Article]" Index="[IX_Main]" Alias="[Extent2]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="1071" EstimateCPU="34.8469" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3134390" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="203.318">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="12" ActualRows="183502" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="16" ActualRows="186820" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="184512" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="181485" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="187612" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="183771" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="191363" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="187913" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="187083" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="192696" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="232582" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="187314" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="234688" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="194768" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="183899" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="234379" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
</PartitionColumns>
<RelOp AvgRowSize="1071" EstimateCPU="0.430998" EstimateIO="168.04" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3134390" LogicalOp="Clustered Index Scan" NodeId="14" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="168.471" TableCardinality="3134390">
<OutputList>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="16" ActualRows="197198" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRows="196333" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="15" ActualRows="206202" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="13" ActualRows="171926" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="14" ActualRows="185924" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="12" ActualRows="233658" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="11" ActualRows="202039" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="10" ActualRows="109613" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="9" ActualRows="199762" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="6" ActualRows="215256" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="7" ActualRows="113820" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="8" ActualRows="208327" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="5" ActualRows="213832" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="266771" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="211610" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="202116" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="SupplierNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="Id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Alias="[Extent1]" Column="ArticleName" />
</DefinedValue>
</DefinedValues>
<Object Database="[DataBase]" Schema="[dbo]" Table="[SalesEntry]" Index="[PK_dbo.SalesEntry]" Alias="[Extent1]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[DataBase].[dbo].[Article].[id] as [Extent2].[id] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataBase]" Schema="[dbo]" Table="[Article]" Alias="[Extent2]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Parallelism>
</RelOp>
</TopSort>
</RelOp>
</ComputeScalar>
</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