-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathplann.html
More file actions
1 lines (1 loc) · 23.7 KB
/
plann.html
File metadata and controls
1 lines (1 loc) · 23.7 KB
1
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="12.0.1524.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="select * from bigProduct p
inner join bigTransactionHistory th
on p.ProductID = th.ProductID
where th.Quantity = 89" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="130.529" StatementEstRows="266351" StatementOptmLevel="FULL" QueryHash="0xE4B1CCD9C4C5CDAD" QueryPlanHash="0x39286BDE91647927" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="64" CompileTime="3" CompileCPU="3" CompileMemory="392"><ThreadStat Branches="3"/><MissingIndexes><MissingIndexGroup Impact="92.5583"><MissingIndex Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]"><ColumnGroup Usage="EQUALITY"><Column Name="[Quantity]" ColumnId="4"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[TransactionID]" ColumnId="1"/><Column Name="[ProductID]" ColumnId="2"/><Column Name="[TransactionDate]" ColumnId="3"/><Column Name="[ActualCost]" ColumnId="5"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="206699" EstimatedPagesCached="51674" EstimatedAvailableDegreeOfParallelism="2"/><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="266351" EstimateIO="0" EstimateCPU="4.61527" AvgRowSize="294" EstimatedTotalSubtreeCost="130.529" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Name"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductNumber"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="MakeFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="FinishedGoodsFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Color"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SafetyStockLevel"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ReorderPoint"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="StandardCost"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ListPrice"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Size"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SizeUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="WeightUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Weight"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DaysToManufacture"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductLine"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Class"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Style"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductSubcategoryID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductModelID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellStartDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellEndDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DiscontinuedDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ActualCost"/></OutputList><Parallelism><RelOp NodeId="1" PhysicalOp="Merge Join" LogicalOp="Inner Join" EstimateRows="266351" EstimateIO="0" EstimateCPU="0.371964" AvgRowSize="294" EstimatedTotalSubtreeCost="125.914" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Name"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductNumber"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="MakeFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="FinishedGoodsFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Color"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SafetyStockLevel"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ReorderPoint"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="StandardCost"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ListPrice"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Size"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SizeUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="WeightUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Weight"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DaysToManufacture"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductLine"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Class"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Style"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductSubcategoryID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductModelID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellStartDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellEndDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DiscontinuedDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ActualCost"/></OutputList><Merge ManyToMany="0"><InnerSideJoinColumns><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/></InnerSideJoinColumns><OuterSideJoinColumns><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/></OuterSideJoinColumns><Residual><ScalarOperator ScalarString="[AdventureWorks2012].[dbo].[bigTransactionHistory].[ProductID] as [th].[ProductID]=[AdventureWorks2012].[dbo].[bigProduct].[ProductID] as [p].[ProductID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/></Identifier></ScalarOperator></Compare></ScalarOperator></Residual><RelOp NodeId="2" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="25200" EstimateIO="0" EstimateCPU="0.539408" AvgRowSize="265" EstimatedTotalSubtreeCost="1.00018" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Name"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductNumber"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="MakeFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="FinishedGoodsFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Color"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SafetyStockLevel"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ReorderPoint"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="StandardCost"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ListPrice"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Size"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SizeUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="WeightUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Weight"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DaysToManufacture"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductLine"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Class"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Style"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductSubcategoryID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductModelID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellStartDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellEndDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DiscontinuedDate"/></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/></PartitionColumns><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="25200" EstimateIO="0.446829" EstimateCPU="0.0139385" AvgRowSize="265" EstimatedTotalSubtreeCost="0.460767" TableCardinality="25200" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Name"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductNumber"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="MakeFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="FinishedGoodsFlag"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Color"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SafetyStockLevel"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ReorderPoint"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="StandardCost"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ListPrice"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Size"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SizeUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="WeightUnitMeasureCode"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Weight"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DaysToManufacture"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductLine"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Class"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Style"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductSubcategoryID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductModelID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellStartDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellEndDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DiscontinuedDate"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductID"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Name"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductNumber"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="MakeFlag"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="FinishedGoodsFlag"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Color"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SafetyStockLevel"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ReorderPoint"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="StandardCost"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ListPrice"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Size"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SizeUnitMeasureCode"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="WeightUnitMeasureCode"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Weight"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DaysToManufacture"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductLine"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Class"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="Style"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductSubcategoryID"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="ProductModelID"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellStartDate"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="SellEndDate"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Alias="[p]" Column="DiscontinuedDate"/></DefinedValue></DefinedValues><Object Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigProduct]" Index="[pk_bigProduct]" Alias="[p]" IndexKind="Clustered" Storage="RowStore"/></IndexScan></RelOp></Parallelism></RelOp><RelOp NodeId="4" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="313701" EstimateIO="0" EstimateCPU="2.53564" AvgRowSize="35" EstimatedTotalSubtreeCost="124.542" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ActualCost"/></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/></PartitionColumns><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="313701" EstimateIO="97.3076" EstimateCPU="17.1951" AvgRowSize="35" EstimatedTotalSubtreeCost="114.503" TableCardinality="3.12636e+007" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionDate"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ActualCost"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionID"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ProductID"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="TransactionDate"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/></DefinedValue><DefinedValue><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="ActualCost"/></DefinedValue></DefinedValues><Object Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Index="[IX_ProductId_TransactionDate]" Alias="[th]" IndexKind="NonClustered" Storage="RowStore"/><Predicate><ScalarOperator ScalarString="[AdventureWorks2012].[dbo].[bigTransactionHistory].[Quantity] as [th].[Quantity]=(89)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[AdventureWorks2012]" Schema="[dbo]" Table="[bigTransactionHistory]" Alias="[th]" Column="Quantity"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(89)"/></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Merge></RelOp></Parallelism></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>