<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;  i_brand_id AS brand_id,&#xa;  i_brand AS brand,&#xa;  t_hour,&#xa;  t_minute,&#xa;  SUM(ext_price) AS ext_price&#xa;FROM item, (&#xa;  SELECT&#xa;    ws_ext_sales_price AS ext_price,&#xa;    ws_sold_date_sk AS sold_date_sk,&#xa;    ws_item_sk AS sold_item_sk,&#xa;    ws_sold_time_sk AS time_sk&#xa;  FROM web_sales, date_dim&#xa;  WHERE&#xa;    d_date_sk = ws_sold_date_sk AND d_moy = 12 AND d_year = 2002&#xa;  UNION ALL&#xa;  SELECT&#xa;    cs_ext_sales_price AS ext_price,&#xa;    cs_sold_date_sk AS sold_date_sk,&#xa;    cs_item_sk AS sold_item_sk,&#xa;    cs_sold_time_sk AS time_sk&#xa;  FROM catalog_sales, date_dim&#xa;  WHERE&#xa;    d_date_sk = cs_sold_date_sk AND d_moy = 12 AND d_year = 2002&#xa;  UNION ALL&#xa;  SELECT&#xa;    ss_ext_sales_price AS ext_price,&#xa;    ss_sold_date_sk AS sold_date_sk,&#xa;    ss_item_sk AS sold_item_sk,&#xa;    ss_sold_time_sk AS time_sk&#xa;  FROM store_sales, date_dim&#xa;  WHERE&#xa;    d_date_sk = ss_sold_date_sk AND d_moy = 12 AND d_year = 2002&#xa;) AS tmp, time_dim&#xa;WHERE&#xa;  sold_item_sk = i_item_sk&#xa;  AND i_manager_id = 1&#xa;  AND time_sk = t_time_sk&#xa;  AND (&#xa;    t_meal_time = &apos;breakfast&apos; OR t_meal_time = &apos;dinner&apos;&#xa;  )&#xa;GROUP BY&#xa;  i_brand,&#xa;  i_brand_id,&#xa;  t_hour,&#xa;  t_minute&#xa;ORDER BY&#xa;  ext_price DESC,&#xa;  i_brand_id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="279.441" StatementEstRows="151033" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xC12E2B8D44AA4680" QueryPlanHash="0x696D54BC6EE65209" 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="368" CompileTime="128" CompileCPU="127" CompileMemory="12464"><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:31:31.69" ModificationCount="0" SamplingPercent="26.4911" Statistics="[_WA_Sys_00000009_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:13.52" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:31.89" ModificationCount="0" SamplingPercent="27.2649" Statistics="[_WA_Sys_00000008_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:30.12" ModificationCount="0" SamplingPercent="26.5637" Statistics="[_WA_Sys_00000001_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:10.58" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:29.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:19.10" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:17.04" ModificationCount="0" SamplingPercent="26.6389" Statistics="[_WA_Sys_00000015_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.43" ModificationCount="0" SamplingPercent="73.9837" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:17.58" ModificationCount="0" SamplingPercent="69.1852" Statistics="[_WA_Sys_00000005_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:25.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:17.36" ModificationCount="0" SamplingPercent="69.2087" Statistics="[_WA_Sys_00000004_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:31.05" ModificationCount="0" SamplingPercent="73.9615" Statistics="[_WA_Sys_00000009_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:16.93" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:17.14" ModificationCount="0" SamplingPercent="69.1205" Statistics="[_WA_Sys_0000000A_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:23.73" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:26.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:03.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.19" ModificationCount="0" SamplingPercent="73.9587" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:11.14" ModificationCount="0" SamplingPercent="69.1757" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="151033" EstimateIO="0" EstimateCPU="0.000755165" AvgRowSize="56" EstimatedTotalSubtreeCost="279.441" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_minute]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="[Expr1020]"><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="151033" EstimateIO="0" EstimateCPU="0.000755165" AvgRowSize="56" EstimatedTotalSubtreeCost="279.441" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="151033" EstimateIO="0.00563063" EstimateCPU="1.78918" AvgRowSize="56" EstimatedTotalSubtreeCost="279.441" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Column="Expr1020"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="151033" EstimateIO="0" EstimateCPU="0" AvgRowSize="56" EstimatedTotalSubtreeCost="277.646" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1073]=(0) THEN NULL ELSE [Expr1074] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1073"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1074"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="151033" EstimateIO="0" EstimateCPU="0.800227" AvgRowSize="56" EstimatedTotalSubtreeCost="277.646" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Column="Expr1073"></ColumnReference><ColumnReference Column="Expr1074"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1073"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1014])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1014"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1074"></ColumnReference><ScalarOperator ScalarString="SUM([Union1014])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1014"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand] = [TPCDS_SF100].[dbo].[item].[i_brand] AND [TPCDS_SF100].[dbo].[item].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] AND [TPCDS_SF100].[dbo].[time_dim].[t_hour] = [TPCDS_SF100].[dbo].[time_dim].[t_hour] AND [TPCDS_SF100].[dbo].[time_dim].[t_minute] = [TPCDS_SF100].[dbo].[time_dim].[t_minute]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="153141" EstimateIO="0" EstimateCPU="0.160795" AvgRowSize="44" EstimatedTotalSubtreeCost="276.846" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Column="Union1014"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1022"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1017"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1017]=[TPCDS_SF100].[dbo].[time_dim].[t_time_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="24905.5" EstimatedRowsRead="86254" EstimateIO="0.0476202" EstimateCPU="0.00950364" AvgRowSize="29" EstimatedTotalSubtreeCost="0.0571238" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_meal_time"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_meal_time"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_meal_time]=&apos;breakfast&apos; OR [TPCDS_SF100].[dbo].[time_dim].[t_meal_time]=&apos;dinner&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_meal_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;breakfast&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_meal_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;dinner&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="9" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="496798" EstimateIO="0" EstimateCPU="0.0026388" AvgRowSize="40" EstimatedTotalSubtreeCost="276.465" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Column="Union1014"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1014"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="77467.6" EstimateIO="0" EstimateCPU="0.0440293" AvgRowSize="40" EstimatedTotalSubtreeCost="39.6587" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1027"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="104.244" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00807199" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0356216" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2002)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2002)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.37043e+06" EstimateIO="0" EstimateCPU="0.0803841" AvgRowSize="44" EstimatedTotalSubtreeCost="39.5286" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1028"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3710.59" EstimatedRowsRead="204328" EstimateIO="0.146496" EstimateCPU="0.0224918" AvgRowSize="39" EstimatedTotalSubtreeCost="0.168988" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_manager_id]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.1898e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="31.2201" EstimateCPU="7.91183" AvgRowSize="24" EstimatedTotalSubtreeCost="39.1319" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_sold_time_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></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="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="155555" EstimateIO="0" EstimateCPU="0.0870828" AvgRowSize="40" EstimatedTotalSubtreeCost="79.1135" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1031"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="104.244" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00807199" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0356216" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2002)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2002)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="17" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.77153e+06" EstimateIO="0" EstimateCPU="0.150596" AvgRowSize="44" EstimatedTotalSubtreeCost="78.9404" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1032"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3710.59" EstimatedRowsRead="3710.59" EstimateIO="0.146496" EstimateCPU="0.0224918" AvgRowSize="39" EstimatedTotalSubtreeCost="0.168988" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_manager_id]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="19" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42967e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="62.5296" EstimateCPU="15.8469" AvgRowSize="24" EstimatedTotalSubtreeCost="78.3765" TableCardinality="1.44063e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_time_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></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="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="294737" EstimateIO="0" EstimateCPU="0.162252" AvgRowSize="40" EstimatedTotalSubtreeCost="157.69" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1035"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="104.244" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00807199" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0356216" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2002)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2002)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.21398e+06" EstimateIO="0" EstimateCPU="0.2745" AvgRowSize="44" EstimatedTotalSubtreeCost="157.442" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1036"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3710.59" EstimatedRowsRead="3710.59" EstimateIO="0.146496" EstimateCPU="0.0224918" AvgRowSize="39" EstimatedTotalSubtreeCost="0.168988" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand"></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_manager_id]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.68545e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="124.905" EstimateCPU="31.6554" AvgRowSize="24" EstimatedTotalSubtreeCost="156.561" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Concat></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
