<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="/* using 19620718 as a seed to the RNG */&#xa;SELECT&#xa;  o_orderpriority,&#xa;  COUNT(*) AS order_count&#xa;FROM orders&#xa;WHERE&#xa;  o_orderdate &gt;= CAST(&apos;1996-07-01&apos; AS DATE)&#xa;  AND o_orderdate &lt; DATEADD(MONTH, 3, CAST(&apos;1996-07-01&apos; AS DATE))&#xa;  AND EXISTS(&#xa;    SELECT&#xa;      *&#xa;    FROM lineitem&#xa;    WHERE&#xa;      l_orderkey = o_orderkey AND l_commitdate &lt; l_receiptdate&#xa;  )&#xa;GROUP BY&#xa;  o_orderpriority&#xa;ORDER BY&#xa;  o_orderpriority" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="548.553" StatementEstRows="5" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF21D8B843FFBC23B" QueryPlanHash="0x172C62D5F2CF1123" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelForPDWCompilation" CachedPlanSize="120" CompileTime="15" CompileCPU="15" CompileMemory="1976"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:16:03.79" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:57.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:29.73" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:26.79" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000006_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:07.45" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:32.68" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="23" EstimatedTotalSubtreeCost="548.553" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderpriority]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="5" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="23" EstimatedTotalSubtreeCost="548.553" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="5" EstimateIO="0.00563063" EstimateCPU="0.000152751" AvgRowSize="23" EstimatedTotalSubtreeCost="548.553" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="548.547" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1009],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="5" EstimateIO="0" EstimateCPU="2.85778" AvgRowSize="23" EstimatedTotalSubtreeCost="548.547" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderpriority] = [TPCH_SF100].[dbo].[orders].[o_orderpriority]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.27635e+06" EstimateIO="0" EstimateCPU="19.3182" AvgRowSize="19" EstimatedTotalSubtreeCost="545.689" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1008"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_orderkey]=[TPCH_SF100].[dbo].[orders].[o_orderkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5.712e+06" EstimatedRowsRead="1.49472e+08" EstimateIO="81.0963" EstimateCPU="16.442" AvgRowSize="30" EstimatedTotalSubtreeCost="97.5382" TableCardinality="1.49472e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderpriority"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderdate]&gt;=&apos;1996-07-01&apos; AND [TPCH_SF100].[dbo].[orders].[o_orderdate]&lt;&apos;1996-10-01&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1996-07-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1996-10-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.16434e+08" EstimateIO="0" EstimateCPU="20.3025" AvgRowSize="15" EstimatedTotalSubtreeCost="325.996" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_orderkey] = [TPCH_SF100].[dbo].[lineitem].[l_orderkey]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="9" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.815e+08" EstimateIO="0" EstimateCPU="9.3775" AvgRowSize="15" EstimatedTotalSubtreeCost="305.693" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.05e+08" EstimatedRowsRead="6.05e+08" EstimateIO="229.766" EstimateCPU="66.55" AvgRowSize="21" EstimatedTotalSubtreeCost="296.316" TableCardinality="6.05e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_commitdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_receiptdate"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_commitdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_receiptdate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_commitdate]&lt;[TPCH_SF100].[dbo].[lineitem].[l_receiptdate]"><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_commitdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_receiptdate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
