<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="&#xa;select min(i_item_id),&#xa;        min(s_state),&#xa;        min(ss_quantity),&#xa;        min(ss_list_price),&#xa;        min(ss_coupon_amt),&#xa;        min(ss_sales_price),&#xa;        min(ss_item_sk),&#xa;        min(ss_ticket_number)&#xa; from store_sales, customer_demographics, date_dim, store, item&#xa; where ss_sold_date_sk = d_date_sk and&#xa;       ss_item_sk = i_item_sk and&#xa;       ss_store_sk = s_store_sk and&#xa;       ss_cdemo_sk = cd_demo_sk and&#xa;       cd_gender = &apos;F&apos; and&#xa;       cd_marital_status = &apos;D&apos; and&#xa;       cd_education_status = &apos;College&apos; and&#xa;       d_year = 2001 and&#xa;       s_state = &apos;IN&apos; and&#xa;      i_category  = &apos;Electronics&apos;" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="284.364" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x8F62AF27791BCFF3" QueryPlanHash="0x8FFE56D2B94E46F2" 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="296" CompileTime="33" CompileCPU="33" CompileMemory="3440"><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-03T18:31:52.89" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:54.05" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.27" ModificationCount="0" SamplingPercent="73.9589" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:39.07" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:55.49" ModificationCount="0" SamplingPercent="26.4701" Statistics="[_WA_Sys_00000001_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:05.14" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.24" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:33.13" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:02.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.25" ModificationCount="0" SamplingPercent="26.6265" Statistics="[_WA_Sys_0000000D_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000019_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.70" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-09" AvgRowSize="50" EstimatedTotalSubtreeCost="284.364" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="[Expr1011]"><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[Expr1012]"><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[Expr1013]"><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="[Expr1014]"><Identifier><ColumnReference Column="Expr1014"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="[Expr1015]"><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="[Expr1016]"><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="[Expr1017]"><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-09" AvgRowSize="50" EstimatedTotalSubtreeCost="284.364" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00240701" AvgRowSize="50" EstimatedTotalSubtreeCost="284.364" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[item].[i_item_id])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store].[s_state])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_quantity])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_coupon_amt])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_sales_price])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_item_sk])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="MIN([DSB_SF100].[dbo].[store_sales].[ss_ticket_number])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="63192.9" EstimateIO="0" EstimateCPU="0.140359" AvgRowSize="50" EstimatedTotalSubtreeCost="284.362" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1039"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="6" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="103831" EstimatedRowsRead="1.91872e+06" EstimateIO="1.04336" EstimateCPU="0.211075" AvgRowSize="30" EstimatedTotalSubtreeCost="1.25443" TableCardinality="1.91872e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_demographics].[cd_gender]=&apos;F&apos; AND [DSB_SF100].[dbo].[customer_demographics].[cd_marital_status]=&apos;D&apos; AND [DSB_SF100].[dbo].[customer_demographics].[cd_education_status]=&apos;College&apos; AND [DSB_SF100].[dbo].[customer_demographics].[cd_gender]=&apos;F&apos; AND [DSB_SF100].[dbo].[customer_demographics].[cd_marital_status]=&apos;D&apos; AND [DSB_SF100].[dbo].[customer_demographics].[cd_education_status]=&apos;College&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;F&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;D&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;College&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;F&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;D&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;College&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="568451" EstimateIO="0" EstimateCPU="0.108049" AvgRowSize="55" EstimatedTotalSubtreeCost="277.752" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1044"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="9" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42201.9" EstimatedRowsRead="203145" EstimateIO="0.116271" EstimateCPU="0.0223617" AvgRowSize="31" EstimatedTotalSubtreeCost="0.138633" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.50982e+06" EstimateIO="0" EstimateCPU="0.0492803" AvgRowSize="44" EstimatedTotalSubtreeCost="277.333" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1046"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="12" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="17" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store].[s_state]=&apos;IN&apos; AND [DSB_SF100].[dbo].[store].[s_state]=&apos;IN&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IN&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IN&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.64317e+07" EstimateIO="0" EstimateCPU="0.0685392" AvgRowSize="42" EstimatedTotalSubtreeCost="277.28" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1029"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[DSB_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2001)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.66183e+08" EstimatedRowsRead="2.88583e+08" EstimateIO="245.29" EstimateCPU="31.7442" AvgRowSize="47" EstimatedTotalSubtreeCost="277.034" TableCardinality="2.88583e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_sales].[ss_cdemo_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_cdemo_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
