<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 20&#xa;  c_custkey,&#xa;  c_name,&#xa;  SUM(l_extendedprice * (&#xa;    1 - l_discount&#xa;  )) AS revenue,&#xa;  c_acctbal,&#xa;  n_name,&#xa;  c_address,&#xa;  c_phone,&#xa;  c_comment&#xa;FROM customer, orders, lineitem, nation&#xa;WHERE&#xa;  c_custkey = o_custkey&#xa;  AND l_orderkey = o_orderkey&#xa;  AND o_orderdate &gt;= CAST(&apos;1993-04-01&apos; AS DATE)&#xa;  AND o_orderdate &lt; DATEADD(MONTH, 3, CAST(&apos;1993-04-01&apos; AS DATE))&#xa;  AND l_returnflag = &apos;R&apos;&#xa;  AND c_nationkey = n_nationkey&#xa;GROUP BY&#xa;  c_custkey,&#xa;  c_name,&#xa;  c_acctbal,&#xa;  c_phone,&#xa;  n_name,&#xa;  c_address,&#xa;  c_comment&#xa;ORDER BY&#xa;  revenue DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="1413.26" StatementEstRows="20" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x5C86A6D462D1DFB3" QueryPlanHash="0x9E3DD62ACAD76AFA" 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="224" CompileTime="40" CompileCPU="40" CompileMemory="4872"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:16:03.79" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:57.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_71D1E811]" Table="[orders]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:16:39.71" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_6EF57B66]" Table="[customer]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:30.45" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_70DDC3D8]" Table="[lineitem]" 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:17:36.03" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000006_6EF57B66]" Table="[customer]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:17:42.50" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_6EF57B66]" Table="[customer]" 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:17:35.57" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_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: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: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><StatisticsInfo LastUpdate="2026-10-03T15:17:34.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_6EF57B66]" Table="[customer]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="20" EstimateIO="0" EstimateCPU="2e-06" AvgRowSize="171" EstimatedTotalSubtreeCost="1413.26" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1008"></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="[customer]" Column="c_address"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_address]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_phone]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_acctbal]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_comment]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference></Identifier></ScalarOperator></DefinedValue><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="Expr1008"></ColumnReference><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="20" EstimateIO="0" EstimateCPU="2e-06" AvgRowSize="171" EstimatedTotalSubtreeCost="1413.26" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="20" EstimateIO="465.968" EstimateCPU="12.8963" AvgRowSize="171" EstimatedTotalSubtreeCost="1413.26" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="20"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Column="Expr1008"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.31021e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="171" EstimatedTotalSubtreeCost="934.399" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1021]=(0) THEN NULL ELSE [Expr1022] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></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="Expr1022"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.31021e+06" EstimateIO="96.8905" EstimateCPU="49.7932" AvgRowSize="171" EstimatedTotalSubtreeCost="934.399" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1009])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1009])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><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="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[customer].[c_custkey] = [TPCH_SF100].[dbo].[customer].[c_custkey] AND [TPCH_SF100].[dbo].[customer].[c_name] = [TPCH_SF100].[dbo].[customer].[c_name] AND [TPCH_SF100].[dbo].[customer].[c_acctbal] = [TPCH_SF100].[dbo].[customer].[c_acctbal] AND [TPCH_SF100].[dbo].[customer].[c_phone] = [TPCH_SF100].[dbo].[customer].[c_phone] AND [TPCH_SF100].[dbo].[nation].[n_name] = [TPCH_SF100].[dbo].[nation].[n_name] AND [TPCH_SF100].[dbo].[customer].[c_address] = [TPCH_SF100].[dbo].[customer].[c_address] AND [TPCH_SF100].[dbo].[customer].[c_comment] = [TPCH_SF100].[dbo].[customer].[c_comment]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><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_custkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_custkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><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></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><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></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.6903e+06" EstimateIO="0" EstimateCPU="3.041" AvgRowSize="171" EstimatedTotalSubtreeCost="787.715" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference><ColumnReference Column="Expr1009"></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="[customer]" Column="c_nationkey"></ColumnReference></HashKeysProbe><RelOp NodeId="7" 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"><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="8" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.6903e+06" EstimateIO="0" EstimateCPU="19.4441" AvgRowSize="166" EstimatedTotalSubtreeCost="784.671" 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="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_nationkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1012"></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="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.42634e+06" EstimateIO="0" EstimateCPU="19.1325" AvgRowSize="32" EstimatedTotalSubtreeCost="723.168" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_custkey"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1011"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_orderkey]=[TPCH_SF100].[dbo].[orders].[o_orderkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5.66218e+06" EstimatedRowsRead="1.49472e+08" EstimateIO="70.2837" EstimateCPU="16.442" AvgRowSize="26" EstimatedTotalSubtreeCost="86.7257" 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></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></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[orders].[o_orderdate]&gt;=&apos;1993-04-01&apos; AND [TPCH_SF100].[dbo].[orders].[o_orderdate]&lt;&apos;1993-07-01&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-04-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[orders]" Column="o_orderdate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;1993-07-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.49045e+08" EstimateIO="0" EstimateCPU="0.0931532" AvgRowSize="32" EstimatedTotalSubtreeCost="514.473" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_orderkey"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></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="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.49045e+08" EstimatedRowsRead="6.05e+08" EstimateIO="415.765" EstimateCPU="66.55" AvgRowSize="38" EstimatedTotalSubtreeCost="482.315" 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_extendedprice"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_discount"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_returnflag"></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_extendedprice"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_discount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_returnflag"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[lineitem].[l_returnflag]=&apos;R&apos; AND [TPCH_SF100].[dbo].[lineitem].[l_returnflag]=&apos;R&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_returnflag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;R&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[lineitem]" Column="l_returnflag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;R&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.49955e+07" EstimatedRowsRead="1.49955e+07" EstimateIO="40.4091" EstimateCPU="1.64952" AvgRowSize="149" EstimatedTotalSubtreeCost="42.0586" 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><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_nationkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></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><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_address"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_nationkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_phone"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_acctbal"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Column="c_comment"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
