<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;  nation,&#xa;  o_year,&#xa;  SUM(amount) AS sum_profit&#xa;FROM (&#xa;  SELECT&#xa;    n_name AS nation,&#xa;    DATEPART(YEAR, o_orderdate) AS o_year,&#xa;    l_extendedprice * (&#xa;      1 - l_discount&#xa;    ) - ps_supplycost * l_quantity AS amount&#xa;  FROM part, supplier, lineitem, partsupp, orders, nation&#xa;  WHERE&#xa;    s_suppkey = l_suppkey&#xa;    AND ps_suppkey = l_suppkey&#xa;    AND ps_partkey = l_partkey&#xa;    AND p_partkey = l_partkey&#xa;    AND o_orderkey = l_orderkey&#xa;    AND s_nationkey = n_nationkey&#xa;    AND p_name LIKE &apos;%powder%&apos;&#xa;) AS profit&#xa;GROUP BY&#xa;  nation,&#xa;  o_year&#xa;ORDER BY&#xa;  nation,&#xa;  o_year DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="2592.67" StatementEstRows="175" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3D49394264BD8C36" QueryPlanHash="0x2BDCAC969953DC18" 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="328" CompileTime="122" CompileCPU="122" CompileMemory="9544"><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: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: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:45.83" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.40" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_75A278F5]" Table="[supplier]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:47.15" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:43.90" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:57.39" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.57" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_6FE99F9F]" Table="[nation]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:44.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_6FE99F9F]" Table="[nation]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:46.22" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_75A278F5]" Table="[supplier]" 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:17:01.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="175" EstimateIO="0" EstimateCPU="5.25e-07" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.67" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[nation].[n_name]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[Expr1012]"><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="[Expr1014]"><Identifier><ColumnReference Column="Expr1014"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="175" EstimateIO="0" EstimateCPU="5.25e-07" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.67" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="175" EstimateIO="0.00563063" EstimateCPU="0.000455186" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.67" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Column="Expr1012"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="175" EstimateIO="0.023125" EstimateCPU="0.0003675" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.66" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="175" EstimateIO="0" EstimateCPU="0" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.63" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1178]=(0) THEN NULL ELSE [Expr1179] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1178"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1179"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="175" EstimateIO="0" EstimateCPU="0.00221753" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.63" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1178"></ColumnReference><ColumnReference Column="Expr1179"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1178"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1016])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1179"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1016])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[nation].[n_name] = [TPCH_SF100].[dbo].[nation].[n_name] AND [Expr1012] = [Expr1012]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="7" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="350" EstimateIO="0.023125" EstimateCPU="0.0003675" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.63" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="partialagg1016"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></DistributionKey><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="350" EstimateIO="0" EstimateCPU="0" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.59" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="partialagg1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1176]=(0) THEN NULL ELSE [Expr1177] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1176"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1177"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="350" EstimateIO="0" EstimateCPU="2.7327" AvgRowSize="39" EstimatedTotalSubtreeCost="2592.59" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1176"></ColumnReference><ColumnReference Column="Expr1177"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1176"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1174])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1174"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1177"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1174])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1174"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[nation].[n_name] = [TPCH_SF100].[dbo].[nation].[n_name] AND [Expr1012] = [Expr1012]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8.17622e+06" EstimateIO="0" EstimateCPU="0.0408811" AvgRowSize="39" EstimatedTotalSubtreeCost="2589.86" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1174"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1174"></ColumnReference><ScalarOperator ScalarString="[Expr1015]-[TPCH_SF100].[dbo].[partsupp].[ps_supplycost]*[TPCH_SF100].[dbo].[lineitem].[l_quantity]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.17622e+06" EstimateIO="0" EstimateCPU="2.49842" AvgRowSize="57" EstimatedTotalSubtreeCost="2589.82" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_nationkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></HashKeysProbe><RelOp NodeId="12" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="25" EstimatedRowsRead="25" EstimateIO="0.003125" EstimateCPU="1.845e-05" AvgRowSize="22" EstimatedTotalSubtreeCost="0.00314345" TableCardinality="25" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_nationkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_nationkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.17622e+06" EstimateIO="0" EstimateCPU="5.40094" AvgRowSize="50" EstimatedTotalSubtreeCost="2587.32" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_suppkey]=[TPCH_SF100].[dbo].[partsupp].[ps_suppkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.00165e+06" EstimatedRowsRead="1.00165e+06" EstimateIO="0.346557" EstimateCPU="0.110197" AvgRowSize="19" EstimatedTotalSubtreeCost="0.456754" TableCardinality="1.00165e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.85611e+06" EstimateIO="13.5012" EstimateCPU="41.6472" AvgRowSize="54" EstimatedTotalSubtreeCost="2581.46" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1116"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderkey]=[TPCH_SF100].[dbo].[lineitem].[l_orderkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="16" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="8.17412e+06" EstimateIO="824.951" EstimateCPU="17.1657" AvgRowSize="58" EstimatedTotalSubtreeCost="2469.39" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="17" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.17412e+06" EstimateIO="0" EstimateCPU="27.3333" AvgRowSize="58" EstimatedTotalSubtreeCost="1431.34" 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_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1127"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_partkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[partsupp].[ps_suppkey]=[TPCH_SF100].[dbo].[lineitem].[l_suppkey] AND [TPCH_SF100].[dbo].[partsupp].[ps_partkey]=[TPCH_SF100].[dbo].[lineitem].[l_partkey]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_partkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="18" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="7.21866e+06" EstimateIO="401.949" EstimateCPU="15.1592" AvgRowSize="32" EstimatedTotalSubtreeCost="736.096" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.21866e+06" EstimateIO="0" EstimateCPU="7.04839" AvgRowSize="32" EstimatedTotalSubtreeCost="223.36" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1129"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_partkey]=[TPCH_SF100].[dbo].[partsupp].[ps_partkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="20" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1.80194e+06" EstimateIO="47.04" EstimateCPU="3.78407" AvgRowSize="15" EstimatedTotalSubtreeCost="165.696" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.80194e+06" EstimatedRowsRead="2.00215e+07" EstimateIO="16.658" EstimateCPU="1.10119" AvgRowSize="46" EstimatedTotalSubtreeCost="17.7592" TableCardinality="2.00215e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_name] like &apos;%powder%&apos; AND [TPCH_SF100].[dbo].[part].[p_name] like &apos;%powder%&apos;"><Logical Operation="AND"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%powder%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%powder%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.987e+07" EstimatedRowsRead="7.987e+07" EstimateIO="46.2235" EstimateCPU="4.39286" AvgRowSize="32" EstimatedTotalSubtreeCost="50.6163" TableCardinality="7.987e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6.05e+08" EstimateIO="0" EstimateCPU="0.0472656" AvgRowSize="57" EstimatedTotalSubtreeCost="667.91" 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_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_extendedprice]*((1.)-[TPCH_SF100].[dbo].[lineitem].[l_discount])"><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_extendedprice"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Const ConstValue="(1.)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_discount"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.05e+08" EstimatedRowsRead="6.05e+08" EstimateIO="634.587" EstimateCPU="33.275" AvgRowSize="58" EstimatedTotalSubtreeCost="667.862" 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_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_extendedprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_discount"></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_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_extendedprice"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_discount"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="26" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.49472e+08" EstimateIO="0" EstimateCPU="0.0467101" AvgRowSize="19" EstimatedTotalSubtreeCost="56.9264" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="datepart(year,[TPCH_SF100].[dbo].[orders].[o_orderdate])"><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.49472e+08" EstimatedRowsRead="1.49472e+08" EstimateIO="48.6587" EstimateCPU="8.22098" AvgRowSize="18" EstimatedTotalSubtreeCost="56.8797" 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_orderdate"></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_orderdate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
