<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;  s_acctbal,&#xa;  s_name,&#xa;  n_name,&#xa;  p_partkey,&#xa;  p_mfgr,&#xa;  s_address,&#xa;  s_phone,&#xa;  s_comment&#xa;FROM part, supplier, partsupp, nation, region&#xa;WHERE&#xa;  p_partkey = ps_partkey&#xa;  AND s_suppkey = ps_suppkey&#xa;  AND p_size = 48&#xa;  AND p_type LIKE &apos;%COPPER&apos;&#xa;  AND s_nationkey = n_nationkey&#xa;  AND n_regionkey = r_regionkey&#xa;  AND r_name = &apos;EUROPE&apos;&#xa;  AND ps_supplycost = (&#xa;    SELECT&#xa;      MIN(ps_supplycost)&#xa;    FROM partsupp, supplier, nation, region&#xa;    WHERE&#xa;      p_partkey = ps_partkey&#xa;      AND s_suppkey = ps_suppkey&#xa;      AND s_nationkey = n_nationkey&#xa;      AND n_regionkey = r_regionkey&#xa;      AND r_name = &apos;EUROPE&apos;&#xa;  )&#xa;ORDER BY&#xa;  s_acctbal DESC,&#xa;  n_name,&#xa;  s_name,&#xa;  p_partkey" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="265.725" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE80E4A7A88CDCCFF" QueryPlanHash="0x982476299D986510" 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="360" CompileTime="58" CompileCPU="58" CompileMemory="5248"><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:18:27.59" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000007_75A278F5]" Table="[supplier]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:45.83" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.40" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_75A278F5]" Table="[supplier]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:47.15" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:49.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.99" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_74AE54BC]" Table="[region]" 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:15:46.22" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_75A278F5]" Table="[supplier]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:42.71" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000006_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.85" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_6FE99F9F]" Table="[nation]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:45.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:15:48.71" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_74AE54BC]" Table="[region]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="163" EstimatedTotalSubtreeCost="265.725" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_partkey]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_mfgr]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_acctbal]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_comment]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_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></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="163" EstimatedTotalSubtreeCost="265.725" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.150998" AvgRowSize="163" EstimatedTotalSubtreeCost="265.724" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="15717" EstimateIO="0" EstimateCPU="0.26699" AvgRowSize="163" EstimatedTotalSubtreeCost="265.568" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1038"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_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].[partsupp].[ps_suppkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="75508.5" EstimateIO="0" EstimateCPU="0.385019" AvgRowSize="39" EstimatedTotalSubtreeCost="262.644" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1024"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1018]=[TPCH_SF100].[dbo].[partsupp].[ps_supplycost] AND [TPCH_SF100].[dbo].[partsupp].[ps_partkey]=[TPCH_SF100].[dbo].[partsupp].[ps_partkey]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="75200" EstimateIO="0" EstimateCPU="0.405154" AvgRowSize="48" EstimatedTotalSubtreeCost="207.25" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1025"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_partkey]=[TPCH_SF100].[dbo].[partsupp].[ps_partkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="121389" EstimatedRowsRead="2.00215e+07" EstimateIO="17.7443" EstimateCPU="2.20238" AvgRowSize="49" EstimatedTotalSubtreeCost="19.9466" TableCardinality="2.00215e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_mfgr"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_type] like &apos;%COPPER&apos; AND [TPCH_SF100].[dbo].[part].[p_size]=(48) AND [TPCH_SF100].[dbo].[part].[p_type] like &apos;%COPPER&apos;"><Logical Operation="AND"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%COPPER&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(48)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%COPPER&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.23511e+07" EstimateIO="0" EstimateCPU="0.34077" AvgRowSize="24" EstimatedTotalSubtreeCost="56.3979" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="MIN([TPCH_SF100].[dbo].[partsupp].[ps_supplycost])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[partsupp].[ps_partkey] = [TPCH_SF100].[dbo].[partsupp].[ps_partkey]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.73209e+07" EstimateIO="0" EstimateCPU="0.451371" AvgRowSize="24" EstimatedTotalSubtreeCost="56.0571" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1034"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_suppkey]=[TPCH_SF100].[dbo].[partsupp].[ps_suppkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="200330" EstimateIO="0" EstimateCPU="0.131689" AvgRowSize="15" EstimatedTotalSubtreeCost="0.596561" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1036"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_nationkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></HashKeysProbe><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5" EstimateIO="0" EstimateCPU="0.00177922" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0080954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_nationkey"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1037"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_regionkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_regionkey"></ColumnReference></HashKeysProbe><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimatedRowsRead="5" EstimateIO="0.003125" EstimateCPU="1.625e-05" AvgRowSize="21" EstimatedTotalSubtreeCost="0.00314125" TableCardinality="5" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_regionkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_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="[region]" Column="r_regionkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[region].[r_name]=&apos;EUROPE&apos; AND [TPCH_SF100].[dbo].[region].[r_name]=&apos;EUROPE&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;EUROPE&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;EUROPE&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="25" EstimatedRowsRead="25" EstimateIO="0.003125" EstimateCPU="1.845e-05" AvgRowSize="15" 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_regionkey"></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_regionkey"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.00165e+06" EstimatedRowsRead="1.00165e+06" EstimateIO="0.346557" EstimateCPU="0.110197" AvgRowSize="19" EstimatedTotalSubtreeCost="0.456754" TableCardinality="1.00165e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.987e+07" EstimatedRowsRead="7.987e+07" EstimateIO="46.2235" EstimateCPU="8.78572" AvgRowSize="32" EstimatedTotalSubtreeCost="55.0092" TableCardinality="7.987e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.987e+07" EstimatedRowsRead="7.987e+07" EstimateIO="46.2235" EstimateCPU="8.78572" AvgRowSize="32" EstimatedTotalSubtreeCost="55.0092" TableCardinality="7.987e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_partkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_supplycost"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="200330" EstimateIO="0" EstimateCPU="0.0180223" AvgRowSize="149" EstimatedTotalSubtreeCost="2.65661" 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 Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_name"></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="[nation]" Column="n_nationkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_nationkey"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5" EstimateIO="0" EstimateCPU="0.00177922" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0080954" 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><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1042"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_regionkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_regionkey"></ColumnReference></HashKeysProbe><RelOp NodeId="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimatedRowsRead="5" EstimateIO="0.003125" EstimateCPU="1.625e-05" AvgRowSize="27" EstimatedTotalSubtreeCost="0.00314125" TableCardinality="5" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_regionkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_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="[region]" Column="r_regionkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[region].[r_name]=&apos;EUROPE&apos; AND [TPCH_SF100].[dbo].[region].[r_name]=&apos;EUROPE&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;EUROPE&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[region]" Column="r_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;EUROPE&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="25" EstimatedRowsRead="25" EstimateIO="0.003125" EstimateCPU="1.845e-05" AvgRowSize="31" 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><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_regionkey"></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><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Column="n_regionkey"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[nation]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.00165e+06" EstimatedRowsRead="1.00165e+06" EstimateIO="2.52028" EstimateCPU="0.110197" AvgRowSize="139" EstimatedTotalSubtreeCost="2.63047" 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_nationkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_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="[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_nationkey"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_phone"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_acctbal"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
