<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;TOP 100&#xa;  c_name,&#xa;  c_custkey,&#xa;  o_orderkey,&#xa;  o_orderdate,&#xa;  o_totalprice,&#xa;  SUM(l_quantity)&#xa;FROM customer, orders, lineitem&#xa;WHERE&#xa;  o_orderkey IN (&#xa;    SELECT&#xa;      l_orderkey&#xa;    FROM lineitem&#xa;    GROUP BY&#xa;      l_orderkey&#xa;    HAVING&#xa;      SUM(l_quantity) &gt; 313&#xa;  )&#xa;  AND c_custkey = o_custkey&#xa;  AND o_orderkey = l_orderkey&#xa;GROUP BY&#xa;  c_name,&#xa;  c_custkey,&#xa;  o_orderkey,&#xa;  o_orderdate,&#xa;  o_totalprice&#xa;ORDER BY&#xa;  o_totalprice DESC,&#xa;  o_orderdate" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="23166.4" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x28223774B556DAF0" QueryPlanHash="0x52EE8C453486F1BC" 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="312" CompileTime="54" CompileCPU="54" CompileMemory="5896"><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:57.91" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6EF57B66]" Table="[customer]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:59.48" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:18:44.35" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:49.10" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:17:31.09" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_6EF57B66]" Table="[customer]" 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></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="5e-06" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_custkey]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_name]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderkey]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_totalprice]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderdate]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="5e-06" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000305577" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0.023125" EstimateCPU="0.00021" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00281532" EstimateCPU="0.00397909" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2900.96" EstimateIO="0" EstimateCPU="0" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1112]=(0) THEN NULL ELSE [Expr1113] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1112"></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="Expr1113"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2900.96" EstimateIO="0" EstimateCPU="0.013487" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference><ColumnReference Column="Expr1113"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1112"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1011])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1113"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1011])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_name] = [TPCH_SF100].[dbo].[customer].[c_name] AND [TPCH_SF100].[dbo].[customer].[c_custkey] = [TPCH_SF100].[dbo].[customer].[c_custkey] AND [TPCH_SF100].[dbo].[orders].[o_orderkey] = [TPCH_SF100].[dbo].[orders].[o_orderkey] AND [TPCH_SF100].[dbo].[orders].[o_orderdate] = [TPCH_SF100].[dbo].[orders].[o_orderdate] AND [TPCH_SF100].[dbo].[orders].[o_totalprice] = [TPCH_SF100].[dbo].[orders].[o_totalprice]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><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="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="8" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="5410.8" EstimateIO="0.357223" EstimateCPU="0.00568134" AvgRowSize="74" EstimatedTotalSubtreeCost="23166.3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="partialagg1011"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></DistributionKey><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5410.8" EstimateIO="0" EstimateCPU="0" AvgRowSize="74" EstimatedTotalSubtreeCost="23165.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="partialagg1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1011"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1110]=(0) THEN NULL ELSE [Expr1111] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1110"></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="Expr1111"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="5410.8" EstimateIO="0" EstimateCPU="0.022565" AvgRowSize="74" EstimatedTotalSubtreeCost="23165.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1110"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1111"></ColumnReference><ScalarOperator ScalarString="SUM([TPCH_SF100].[dbo].[lineitem].[l_quantity])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_name] = [TPCH_SF100].[dbo].[customer].[c_name] AND [TPCH_SF100].[dbo].[customer].[c_custkey] = [TPCH_SF100].[dbo].[customer].[c_custkey] AND [TPCH_SF100].[dbo].[orders].[o_orderkey] = [TPCH_SF100].[dbo].[orders].[o_orderkey] AND [TPCH_SF100].[dbo].[orders].[o_orderdate] = [TPCH_SF100].[dbo].[orders].[o_orderdate] AND [TPCH_SF100].[dbo].[orders].[o_totalprice] = [TPCH_SF100].[dbo].[orders].[o_totalprice]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><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="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="11285.1" EstimateIO="0" EstimateCPU="0.0252288" AvgRowSize="66" EstimatedTotalSubtreeCost="23165.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1059"></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="[lineitem]" Column="l_orderkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_orderkey]=[TPCH_SF100].[dbo].[lineitem].[l_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="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="3141.06" EstimateIO="0.364129" EstimateCPU="0.00659622" AvgRowSize="65" EstimatedTotalSubtreeCost="22869.9" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="3141.06" EstimateIO="0" EstimateCPU="0.0139229" AvgRowSize="65" EstimatedTotalSubtreeCost="22869.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1063"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_custkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_custkey]=[TPCH_SF100].[dbo].[orders].[o_custkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_custkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="14" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2995.35" EstimateIO="0.232986" EstimateCPU="0.00629024" AvgRowSize="43" EstimatedTotalSubtreeCost="22858.5" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2995.35" EstimateIO="0" EstimateCPU="0.00837563" AvgRowSize="43" EstimatedTotalSubtreeCost="22858.2" 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_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1041"></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="2878.37" EstimateIO="0.0839972" EstimateCPU="0.00604458" AvgRowSize="15" EstimatedTotalSubtreeCost="22755.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="17" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="2878.37" EstimateIO="0" EstimateCPU="19.2847" AvgRowSize="15" EstimatedTotalSubtreeCost="22755.3" 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="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.55522e+08" EstimateIO="0" EstimateCPU="0" AvgRowSize="32" EstimatedTotalSubtreeCost="22736" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1108]=(0) THEN NULL ELSE [Expr1109] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1108"></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="Expr1109"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.55522e+08" EstimateIO="3145.69" EstimateCPU="347.498" AvgRowSize="32" EstimatedTotalSubtreeCost="22736" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1010])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1010])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></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="20" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="2.90065e+08" EstimateIO="8075.53" EstimateCPU="304.569" AvgRowSize="32" EstimatedTotalSubtreeCost="19242.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="partialagg1010"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></DistributionKey><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.90065e+08" EstimateIO="0" EstimateCPU="0" AvgRowSize="32" EstimatedTotalSubtreeCost="7005.78" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="partialagg1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1106]=(0) THEN NULL ELSE [Expr1107] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1106"></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="Expr1107"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2.90065e+08" EstimateIO="6118.33" EstimateCPU="591.586" AvgRowSize="32" EstimatedTotalSubtreeCost="7005.78" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1106"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1107"></ColumnReference><ScalarOperator ScalarString="SUM([TPCH_SF100].[dbo].[lineitem].[l_quantity])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></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="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.05e+08" EstimatedRowsRead="6.05e+08" EstimateIO="262.589" EstimateCPU="33.275" AvgRowSize="24" EstimatedTotalSubtreeCost="295.864" 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_quantity"></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_quantity"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1008]&gt;(313.00)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(313.00)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Move></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.49472e+08" EstimatedRowsRead="1.49472e+08" EstimateIO="94.6119" EstimateCPU="8.22098" AvgRowSize="35" EstimatedTotalSubtreeCost="102.833" 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_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></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_custkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_totalprice"></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></Hash></RelOp></Move></RelOp><RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.49955e+07" EstimatedRowsRead="1.49955e+07" EstimateIO="10.0363" EstimateCPU="0.82476" AvgRowSize="37" EstimatedTotalSubtreeCost="10.861" TableCardinality="1.49955e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_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="[customer]" Column="c_custkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="26" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.05e+08" EstimatedRowsRead="6.05e+08" EstimateIO="262.589" EstimateCPU="33.275" AvgRowSize="24" EstimatedTotalSubtreeCost="295.864" 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_quantity"></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_quantity"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
