By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT 
 P.*
FROM Production.Product AS P
JOIN Production.ProductModel AS PM
 ON PM.ProductModelID = P.ProductModelID" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0393008" StatementEstRows="295" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xFBAC81FC99A05827" QueryPlanHash="0x8153A5A1BA42FACD" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="80" CompileTime="31" CompileCPU="31" CompileMemory="368"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1112" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2354416"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-11-23T18:04:36.09" ModificationCount="0" SamplingPercent="100" Statistics="[PK_ProductModel_ProductModelID]" Table="[ProductModel]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-11-23T18:04:39.64" ModificationCount="0" SamplingPercent="100" Statistics="[AK_Product_Name]" Table="[Product]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-11-23T18:04:39.61" ModificationCount="0" SamplingPercent="100" Statistics="[AK_Product_ProductNumber]" Table="[Product]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-11-23T18:04:39.64" ModificationCount="0" SamplingPercent="100" Statistics="[AK_Product_rowguid]" Table="[Product]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-11-23T18:05:00.01" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000014_1CBC4616]" Table="[Product]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="295" EstimateIO="0" EstimateCPU="0.0231497" AvgRowSize="229" EstimatedTotalSubtreeCost="0.0393008" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductNumber"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="MakeFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="FinishedGoodsFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Color"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SafetyStockLevel"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ReorderPoint"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="StandardCost"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ListPrice"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Size"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SizeUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="WeightUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Weight"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DaysToManufacture"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductLine"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Class"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Style"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductSubcategoryID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellStartDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellEndDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DiscontinuedDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="rowguid"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ModifiedDate"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[ProductModel]" Alias="[PM]" Column="ProductModelID"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_0ca83e58af4949889d28f7b6f0c04050].[Production].[Product].[ProductModelID] as [P].[ProductModelID]=[fiddle_0ca83e58af4949889d28f7b6f0c04050].[Production].[ProductModel].[ProductModelID] as [PM].[ProductModelID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[ProductModel]" Alias="[PM]" Column="ProductModelID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="1" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="128" EstimatedRowsRead="128" EstimateIO="0.003125" EstimateCPU="0.0002978" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0034228" TableCardinality="128" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[ProductModel]" Alias="[PM]" Column="ProductModelID"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[ProductModel]" Alias="[PM]" Column="ProductModelID"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[ProductModel]" Index="[AK_ProductModel_rowguid]" Alias="[PM]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="504" EstimatedRowsRead="504" EstimateIO="0.0120139" EstimateCPU="0.0007114" AvgRowSize="229" EstimatedTotalSubtreeCost="0.0127253" TableCardinality="504" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductNumber"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="MakeFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="FinishedGoodsFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Color"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SafetyStockLevel"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ReorderPoint"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="StandardCost"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ListPrice"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Size"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SizeUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="WeightUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Weight"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DaysToManufacture"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductLine"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Class"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Style"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductSubcategoryID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellStartDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellEndDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DiscontinuedDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="rowguid"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ModifiedDate"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductNumber"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="MakeFlag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="FinishedGoodsFlag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Color"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SafetyStockLevel"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ReorderPoint"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="StandardCost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ListPrice"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Size"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SizeUnitMeasureCode"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="WeightUnitMeasureCode"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Weight"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DaysToManufacture"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductLine"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Class"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Style"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductSubcategoryID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellStartDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellEndDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DiscontinuedDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="rowguid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ModifiedDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Index="[PK_Product_ProductID]" Alias="[P]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Hash></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT 
 P.*
FROM Production.Product AS P
JOIN Production.ProductModel AS PM
 ON PM.ProductModelID = P.ProductModelID
WHERE
 P.ProductModelID IS NOT NULL" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0127253" StatementEstRows="295" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x61F1F12EB1EE9078" QueryPlanHash="0x0DA11AA10A268A7B" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="352"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2354416"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-11-23T18:04:36.09" ModificationCount="0" SamplingPercent="100" Statistics="[PK_ProductModel_ProductModelID]" Table="[ProductModel]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-11-23T18:05:00.01" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000014_1CBC4616]" Table="[Product]" Schema="[Production]" Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="295" EstimatedRowsRead="504" EstimateIO="0.0120139" EstimateCPU="0.0007114" AvgRowSize="229" EstimatedTotalSubtreeCost="0.0127253" TableCardinality="504" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductNumber"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="MakeFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="FinishedGoodsFlag"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Color"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SafetyStockLevel"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ReorderPoint"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="StandardCost"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ListPrice"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Size"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SizeUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="WeightUnitMeasureCode"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Weight"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DaysToManufacture"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductLine"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Class"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Style"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductSubcategoryID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellStartDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellEndDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DiscontinuedDate"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="rowguid"></ColumnReference><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ModifiedDate"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductNumber"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="MakeFlag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="FinishedGoodsFlag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Color"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SafetyStockLevel"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ReorderPoint"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="StandardCost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ListPrice"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Size"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SizeUnitMeasureCode"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="WeightUnitMeasureCode"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Weight"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DaysToManufacture"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductLine"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Class"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="Style"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductSubcategoryID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellStartDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="SellEndDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="DiscontinuedDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="rowguid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ModifiedDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Index="[PK_Product_ProductID]" Alias="[P]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_0ca83e58af4949889d28f7b6f0c04050].[Production].[Product].[ProductModelID] as [P].[ProductModelID] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_0ca83e58af4949889d28f7b6f0c04050]" Schema="[Production]" Table="[Product]" Alias="[P]" Column="ProductModelID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |