<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH revenue0(supplier_no, total_revenue) AS (&#xa;  SELECT&#xa;    l_suppkey,&#xa;    SUM(l_extendedprice * (&#xa;      1 - l_discount&#xa;    ))&#xa;  FROM lineitem&#xa;  WHERE&#xa;    l_shipdate &gt;= CAST(&apos;1993-07-01&apos; AS DATE)&#xa;    AND l_shipdate &lt; DATEADD(MONTH, 3, CAST(&apos;1993-07-01&apos; AS DATE))&#xa;  GROUP BY&#xa;    l_suppkey&#xa;)&#xa;SELECT&#xa;  s_suppkey,&#xa;  s_name,&#xa;  s_address,&#xa;  s_phone,&#xa;  total_revenue&#xa;FROM supplier, revenue0&#xa;WHERE&#xa;  s_suppkey = supplier_no&#xa;  AND total_revenue = (&#xa;    SELECT&#xa;      MAX(total_revenue)&#xa;    FROM revenue0&#xa;  )&#xa;ORDER BY&#xa;  s_suppkey" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="1357.05" StatementEstRows="1.04035" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4CB89C6A02CDAF8E" QueryPlanHash="0x9231E73E90345E70" 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="192" CompileTime="26" CompileCPU="26" CompileMemory="2920"><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:27.25" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_70DDC3D8]" Table="[lineitem]" 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:51.40" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[lineitem]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:18:21.29" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000006_70DDC3D8]" Table="[lineitem]" 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></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.04035" EstimateIO="0" EstimateCPU="5.20173e-09" AvgRowSize="79" EstimatedTotalSubtreeCost="1357.05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_suppkey]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_name"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_name]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_address]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_phone]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1.04035" EstimateIO="0" EstimateCPU="5.20173e-09" AvgRowSize="79" EstimatedTotalSubtreeCost="1357.05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1.04035" EstimateIO="0.00563063" EstimateCPU="0.000150132" AvgRowSize="79" EstimatedTotalSubtreeCost="1357.05" 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_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04035" EstimateIO="0" EstimateCPU="0.00177937" AvgRowSize="79" EstimatedTotalSubtreeCost="1357.05" 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_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1016"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_suppkey]=[TPCH_SF100].[dbo].[lineitem].[l_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="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177878" AvgRowSize="32" EstimatedTotalSubtreeCost="1355.81" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1017"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1008"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1004"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1008]=[Expr1004]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0114029" AvgRowSize="24" EstimatedTotalSubtreeCost="895.373" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1007])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="962785" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="895.362" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1018]=(0) THEN NULL ELSE [Expr1019] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></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="Expr1019"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="962785" EstimateIO="0" EstimateCPU="18.4577" AvgRowSize="24" EstimatedTotalSubtreeCost="895.362" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1011])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1011])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_suppkey] = [TPCH_SF100].[dbo].[lineitem].[l_suppkey]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.31458e+07" EstimateIO="0" EstimateCPU="0.231458" AvgRowSize="32" EstimatedTotalSubtreeCost="876.904" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></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="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.31458e+07" EstimatedRowsRead="6.05e+08" EstimateIO="393.883" EstimateCPU="66.55" AvgRowSize="36" EstimatedTotalSubtreeCost="460.433" TableCardinality="6.05e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></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_suppkey"></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]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_shipdate]&gt;=&apos;1993-07-01&apos; AND [TPCH_SF100].[dbo].[lineitem].[l_shipdate]&lt;&apos;1993-10-01&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_shipdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-07-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_shipdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-10-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="962785" EstimateIO="0" EstimateCPU="0" AvgRowSize="32" EstimatedTotalSubtreeCost="460.435" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1020]=(0) THEN NULL ELSE [Expr1021] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></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="Expr1021"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="962785" EstimateIO="0" EstimateCPU="0.0018102" AvgRowSize="32" EstimatedTotalSubtreeCost="460.435" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1010])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1010])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_suppkey] = [TPCH_SF100].[dbo].[lineitem].[l_suppkey]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.31458e+07" EstimateIO="0" EstimateCPU="4.41471e-07" AvgRowSize="32" EstimatedTotalSubtreeCost="460.433" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></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="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.31458e+07" EstimatedRowsRead="6.05e+08" EstimateIO="393.883" EstimateCPU="66.55" AvgRowSize="36" EstimatedTotalSubtreeCost="460.433" TableCardinality="6.05e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_suppkey"></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_suppkey"></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]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_shipdate]&gt;=&apos;1993-07-01&apos; AND [TPCH_SF100].[dbo].[lineitem].[l_shipdate]&lt;&apos;1993-10-01&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_shipdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-07-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_shipdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-10-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.00165e+06" EstimatedRowsRead="1.00165e+06" EstimateIO="1.12547" EstimateCPU="0.110197" AvgRowSize="62" EstimatedTotalSubtreeCost="1.23567" 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_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><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_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_address"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
