<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;  p_brand,&#xa;  p_type,&#xa;  p_size,&#xa;  COUNT(DISTINCT ps_suppkey) AS supplier_cnt&#xa;FROM partsupp, part&#xa;WHERE&#xa;  p_partkey = ps_partkey&#xa;  AND p_brand &lt;&gt; &apos;Brand#55&apos;&#xa;  AND p_type NOT LIKE &apos;MEDIUM ANODIZED%&apos;&#xa;  AND p_size IN (35, 30, 37, 33, 8, 48, 6, 16)&#xa;  AND NOT ps_suppkey IN (&#xa;    SELECT&#xa;      s_suppkey&#xa;    FROM supplier&#xa;    WHERE&#xa;      s_comment LIKE &apos;%Customer%Complaints%&apos;&#xa;  )&#xa;GROUP BY&#xa;  p_brand,&#xa;  p_type,&#xa;  p_size&#xa;ORDER BY&#xa;  supplier_cnt DESC,&#xa;  p_brand,&#xa;  p_type,&#xa;  p_size" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="341.873" StatementEstRows="28800" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xBB6A3978A30DDFD7" QueryPlanHash="0x1E25B4C6E68DC957" 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="22" CompileCPU="22" CompileMemory="2320"><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:47.15" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[partsupp]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:18:28.17" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_72C60C4A]" Table="[part]" 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: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:45.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_72C60C4A]" Table="[part]" Schema="[dbo]" Database="[TPCH_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="28800" EstimateIO="0" EstimateCPU="0.0001152" AvgRowSize="49" EstimatedTotalSubtreeCost="341.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_brand]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_type]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_size]"><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="[Expr1006]"><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="28800" EstimateIO="0" EstimateCPU="0.0001152" AvgRowSize="49" EstimatedTotalSubtreeCost="341.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="28800" EstimateIO="0.00563063" EstimateCPU="0.29389" AvgRowSize="49" EstimatedTotalSubtreeCost="341.872" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Column="Expr1006"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="28800" EstimateIO="0" EstimateCPU="0" AvgRowSize="49" EstimatedTotalSubtreeCost="341.573" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1011],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="28800" EstimateIO="0" EstimateCPU="5.64113" AvgRowSize="49" EstimatedTotalSubtreeCost="341.573" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_brand] = [TPCH_SF100].[dbo].[part].[p_brand] AND [TPCH_SF100].[dbo].[part].[p_type] = [TPCH_SF100].[dbo].[part].[p_type] AND [TPCH_SF100].[dbo].[part].[p_size] = [TPCH_SF100].[dbo].[part].[p_size]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="8.23194e+06" EstimateIO="0" EstimateCPU="47.749" AvgRowSize="53" EstimatedTotalSubtreeCost="335.932" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[part].[p_brand] = [TPCH_SF100].[dbo].[part].[p_brand] AND [TPCH_SF100].[dbo].[part].[p_type] = [TPCH_SF100].[dbo].[part].[p_type] AND [TPCH_SF100].[dbo].[part].[p_size] = [TPCH_SF100].[dbo].[part].[p_size] AND [TPCH_SF100].[dbo].[partsupp].[ps_suppkey] = [TPCH_SF100].[dbo].[partsupp].[ps_suppkey]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.23311e+06" EstimateIO="0" EstimateCPU="16.6731" AvgRowSize="53" EstimatedTotalSubtreeCost="288.183" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1010"></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="9" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.26655e+06" EstimatedRowsRead="2.00215e+07" EstimateIO="19.1926" EstimateCPU="2.20238" AvgRowSize="53" EstimatedTotalSubtreeCost="21.395" 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_brand"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></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_brand"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="NOT [TPCH_SF100].[dbo].[part].[p_type] like &apos;MEDIUM ANODIZED%&apos; AND [TPCH_SF100].[dbo].[part].[p_brand]&lt;&gt;&apos;Brand#55&apos; AND [TPCH_SF100].[dbo].[part].[p_brand]&lt;&gt;&apos;Brand#55&apos; AND ([TPCH_SF100].[dbo].[part].[p_size]=(6) OR [TPCH_SF100].[dbo].[part].[p_size]=(8) OR [TPCH_SF100].[dbo].[part].[p_size]=(16) OR [TPCH_SF100].[dbo].[part].[p_size]=(30) OR [TPCH_SF100].[dbo].[part].[p_size]=(33) OR [TPCH_SF100].[dbo].[part].[p_size]=(35) OR [TPCH_SF100].[dbo].[part].[p_size]=(37) OR [TPCH_SF100].[dbo].[part].[p_size]=(48))"><Logical Operation="AND"><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;MEDIUM ANODIZED%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Brand#55&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_brand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Brand#55&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(16)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(33)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(35)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[part]" Column="p_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(37)"></Const></ScalarOperator></Compare></ScalarOperator><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></Logical></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Right Anti Semi Join" EstimateRows="7.2421e+07" EstimateIO="0" EstimateCPU="7.66726" AvgRowSize="23" EstimatedTotalSubtreeCost="62.3529" 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></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[partsupp].[ps_suppkey]=[TPCH_SF100].[dbo].[supplier].[s_suppkey]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Column="ps_suppkey"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_suppkey"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="90148.5" EstimatedRowsRead="1.00165e+06" EstimateIO="1.46965" EstimateCPU="0.110197" AvgRowSize="81" EstimatedTotalSubtreeCost="1.57984" 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_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_comment"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCH_SF100].[dbo].[supplier].[s_comment] like &apos;%Customer%Complaints%&apos; AND [TPCH_SF100].[dbo].[supplier].[s_comment] like &apos;%Customer%Complaints%&apos;"><Logical Operation="AND"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%Customer%Complaints%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[TPCH_SF100]" Schema="[dbo]" Table="[supplier]" Column="s_comment"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%Customer%Complaints%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.987e+07" EstimatedRowsRead="7.987e+07" EstimateIO="33.2238" EstimateCPU="8.78572" AvgRowSize="23" EstimatedTotalSubtreeCost="42.0095" 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></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></DefinedValues><Object Database="[TPCH_SF100]" Schema="[dbo]" Table="[partsupp]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
