<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT DISTINCT&#xa;TOP 100&#xa;  i_product_name&#xa;FROM item AS i1&#xa;WHERE&#xa;  i_manufact_id BETWEEN 697 AND 697 + 40&#xa;  AND (&#xa;    SELECT&#xa;      COUNT(*) AS item_cnt&#xa;    FROM item&#xa;    WHERE&#xa;      (&#xa;        i_manufact = i1.i_manufact&#xa;        AND (&#xa;          (&#xa;            i_category = &apos;Women&apos;&#xa;            AND (&#xa;              i_color = &apos;bisque&apos; OR i_color = &apos;peach&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Pound&apos; OR i_units = &apos;Each&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;medium&apos; OR i_size = &apos;small&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Women&apos;&#xa;            AND (&#xa;              i_color = &apos;green&apos; OR i_color = &apos;white&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Carton&apos; OR i_units = &apos;Oz&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;petite&apos; OR i_size = &apos;N/A&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Men&apos;&#xa;            AND (&#xa;              i_color = &apos;light&apos; OR i_color = &apos;tomato&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Case&apos; OR i_units = &apos;Tsp&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;economy&apos; OR i_size = &apos;large&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Men&apos;&#xa;            AND (&#xa;              i_color = &apos;floral&apos; OR i_color = &apos;black&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Dram&apos; OR i_units = &apos;Dozen&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;medium&apos; OR i_size = &apos;small&apos;&#xa;            )&#xa;          )&#xa;        )&#xa;      )&#xa;      OR (&#xa;        i_manufact = i1.i_manufact&#xa;        AND (&#xa;          (&#xa;            i_category = &apos;Women&apos;&#xa;            AND (&#xa;              i_color = &apos;khaki&apos; OR i_color = &apos;papaya&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Cup&apos; OR i_units = &apos;Ounce&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;medium&apos; OR i_size = &apos;small&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Women&apos;&#xa;            AND (&#xa;              i_color = &apos;goldenrod&apos; OR i_color = &apos;firebrick&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Ton&apos; OR i_units = &apos;Gross&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;petite&apos; OR i_size = &apos;N/A&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Men&apos;&#xa;            AND (&#xa;              i_color = &apos;peru&apos; OR i_color = &apos;almond&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Gram&apos; OR i_units = &apos;N/A&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;economy&apos; OR i_size = &apos;large&apos;&#xa;            )&#xa;          )&#xa;          OR (&#xa;            i_category = &apos;Men&apos;&#xa;            AND (&#xa;              i_color = &apos;thistle&apos; OR i_color = &apos;mint&apos;&#xa;            )&#xa;            AND (&#xa;              i_units = &apos;Bundle&apos; OR i_units = &apos;Bunch&apos;&#xa;            )&#xa;            AND (&#xa;              i_size = &apos;medium&apos; OR i_size = &apos;small&apos;&#xa;            )&#xa;          )&#xa;        )&#xa;      )&#xa;  ) &gt; 0&#xa;ORDER BY&#xa;  i_product_name" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="11.9335" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD0712B5E9C49E2A5" QueryPlanHash="0x7AEF265078B83BC5" 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="240" CompileTime="19" CompileCPU="19" 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:32:34.35" ModificationCount="0" SamplingPercent="26.6099" Statistics="[_WA_Sys_0000000D_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:43.62" ModificationCount="0" SamplingPercent="26.2565" Statistics="[_WA_Sys_00000013_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:29.90" ModificationCount="0" SamplingPercent="26.3404" Statistics="[_WA_Sys_00000012_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:17.41" ModificationCount="0" SamplingPercent="26.6988" Statistics="[_WA_Sys_0000000F_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:43.90" ModificationCount="0" SamplingPercent="26.4105" Statistics="[_WA_Sys_00000010_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:31.28" ModificationCount="0" SamplingPercent="26.5731" Statistics="[_WA_Sys_0000000E_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:30.62" ModificationCount="0" SamplingPercent="26.7017" Statistics="[_WA_Sys_00000016_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="33" EstimatedTotalSubtreeCost="11.9335" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_product_name] as [i1].[i_product_name]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="33" EstimatedTotalSubtreeCost="11.9335" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.00470287" AvgRowSize="33" EstimatedTotalSubtreeCost="11.9335" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1799.32" EstimateIO="0" EstimateCPU="0.00856016" AvgRowSize="33" EstimatedTotalSubtreeCost="11.9231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_product_name] as [i1].[i_product_name] = [TPCDS_SF100].[dbo].[item].[i_product_name] as [i1].[i_product_name]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1809.42" EstimateIO="0" EstimateCPU="0.00597859" AvgRowSize="33" EstimatedTotalSubtreeCost="11.9146" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1005"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_manufact]=[TPCDS_SF100].[dbo].[item].[i_manufact] as [i1].[i_manufact]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="731.161" EstimateIO="0" EstimateCPU="0.00539494" AvgRowSize="36" EstimatedTotalSubtreeCost="11.3887" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_manufact] = [TPCDS_SF100].[dbo].[item].[i_manufact]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="7" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1754.89" EstimateIO="0" EstimateCPU="11.1293" AvgRowSize="36" EstimatedTotalSubtreeCost="11.3833" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1754.89" EstimatedRowsRead="204328" EstimateIO="0.231485" EstimateCPU="0.0224918" AvgRowSize="62" EstimatedTotalSubtreeCost="0.253976" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_manufact] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_manufact] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_category]=&apos;Women&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;bisque&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;peach&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Each&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Pound&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;medium&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;small&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Women&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;green&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;white&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Carton&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Oz&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;N/A&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;petite&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Men&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;light&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;tomato&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Case&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Tsp&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;economy&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;large&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Men&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;black&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;floral&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Dozen&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Dram&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;medium&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;small&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Women&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;khaki&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;papaya&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Cup&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Ounce&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;medium&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;small&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Women&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;firebrick&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;goldenrod&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Gross&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Ton&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;N/A&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;petite&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Men&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;almond&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;peru&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Gram&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;N/A&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;economy&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;large&apos;) OR [TPCDS_SF100].[dbo].[item].[i_category]=&apos;Men&apos; AND ([TPCDS_SF100].[dbo].[item].[i_color]=&apos;mint&apos; OR [TPCDS_SF100].[dbo].[item].[i_color]=&apos;thistle&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_units]=&apos;Bunch&apos; OR [TPCDS_SF100].[dbo].[item].[i_units]=&apos;Bundle&apos;) AND ([TPCDS_SF100].[dbo].[item].[i_size]=&apos;medium&apos; OR [TPCDS_SF100].[dbo].[item].[i_size]=&apos;small&apos;)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Women&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;bisque&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;peach&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Each&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Pound&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;medium&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;small&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Women&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;green&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;white&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Carton&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Oz&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N/A&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;petite&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Men&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;light&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;tomato&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Case&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Tsp&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;economy&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;large&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Men&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;black&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;floral&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Dozen&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Dram&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;medium&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;small&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Women&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;khaki&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;papaya&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Cup&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Ounce&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;medium&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;small&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Women&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;firebrick&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;goldenrod&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Gross&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Ton&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N/A&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;petite&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Men&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;almond&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;peru&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Gram&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N/A&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;economy&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;large&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Men&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;mint&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_color"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;thistle&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Bunch&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_units"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Bundle&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;medium&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_size"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;small&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp><RelOp NodeId="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2467.37" EstimatedRowsRead="204328" EstimateIO="0.187143" EstimateCPU="0.0224918" AvgRowSize="50" EstimatedTotalSubtreeCost="0.209634" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_product_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[i1]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_manufact] as [i1].[i_manufact] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_manufact_id] as [i1].[i_manufact_id]&gt;=(697) AND [TPCDS_SF100].[dbo].[item].[i_manufact_id] as [i1].[i_manufact_id]&lt;=(737) AND [TPCDS_SF100].[dbo].[item].[i_manufact] as [i1].[i_manufact] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(697)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(737)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[i1]" Column="i_manufact"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
