<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH cross_items AS (&#xa;  SELECT&#xa;    i_item_sk AS ss_item_sk&#xa;  FROM item, (&#xa;    SELECT&#xa;      iss.i_brand_id AS brand_id,&#xa;      iss.i_class_id AS class_id,&#xa;      iss.i_category_id AS category_id&#xa;    FROM store_sales, item AS iss, date_dim AS d1&#xa;    WHERE&#xa;      ss_item_sk = iss.i_item_sk&#xa;      AND ss_sold_date_sk = d1.d_date_sk&#xa;      AND d1.d_year BETWEEN 1999 AND 1999 + 2&#xa;    INTERSECT&#xa;    SELECT&#xa;      ics.i_brand_id,&#xa;      ics.i_class_id,&#xa;      ics.i_category_id&#xa;    FROM catalog_sales, item AS ics, date_dim AS d2&#xa;    WHERE&#xa;      cs_item_sk = ics.i_item_sk&#xa;      AND cs_sold_date_sk = d2.d_date_sk&#xa;      AND d2.d_year BETWEEN 1999 AND 1999 + 2&#xa;    INTERSECT&#xa;    SELECT&#xa;      iws.i_brand_id,&#xa;      iws.i_class_id,&#xa;      iws.i_category_id&#xa;    FROM web_sales, item AS iws, date_dim AS d3&#xa;    WHERE&#xa;      ws_item_sk = iws.i_item_sk&#xa;      AND ws_sold_date_sk = d3.d_date_sk&#xa;      AND d3.d_year BETWEEN 1999 AND 1999 + 2&#xa;  ) AS x&#xa;  WHERE&#xa;    i_brand_id = brand_id AND i_class_id = class_id AND i_category_id = category_id&#xa;), avg_sales AS (&#xa;  SELECT&#xa;    AVG(quantity * list_price) AS average_sales&#xa;  FROM (&#xa;    SELECT&#xa;      ss_quantity AS quantity,&#xa;      ss_list_price AS list_price&#xa;    FROM store_sales, date_dim&#xa;    WHERE&#xa;      ss_sold_date_sk = d_date_sk AND d_year BETWEEN 1999 AND 1999 + 2&#xa;    UNION ALL&#xa;    SELECT&#xa;      cs_quantity AS quantity,&#xa;      cs_list_price AS list_price&#xa;    FROM catalog_sales, date_dim&#xa;    WHERE&#xa;      cs_sold_date_sk = d_date_sk AND d_year BETWEEN 1999 AND 1999 + 2&#xa;    UNION ALL&#xa;    SELECT&#xa;      ws_quantity AS quantity,&#xa;      ws_list_price AS list_price&#xa;    FROM web_sales, date_dim&#xa;    WHERE&#xa;      ws_sold_date_sk = d_date_sk AND d_year BETWEEN 1999 AND 1999 + 2&#xa;  ) AS x&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  this_year.channel AS ty_channel,&#xa;  this_year.i_brand_id AS ty_brand,&#xa;  this_year.i_class_id AS ty_class,&#xa;  this_year.i_category_id AS ty_category,&#xa;  this_year.sales AS ty_sales,&#xa;  this_year.number_sales AS ty_number_sales,&#xa;  last_year.channel AS ly_channel,&#xa;  last_year.i_brand_id AS ly_brand,&#xa;  last_year.i_class_id AS ly_class,&#xa;  last_year.i_category_id AS ly_category,&#xa;  last_year.sales AS ly_sales,&#xa;  last_year.number_sales AS ly_number_sales&#xa;FROM (&#xa;  SELECT&#xa;    &apos;store&apos; AS channel,&#xa;    i_brand_id AS i_brand_id,&#xa;    i_class_id AS i_class_id,&#xa;    i_category_id AS i_category_id,&#xa;    SUM(ss_quantity * ss_list_price) AS sales,&#xa;    COUNT(*) AS number_sales&#xa;  FROM store_sales, item, date_dim&#xa;  WHERE&#xa;    ss_item_sk IN (&#xa;      SELECT&#xa;        ss_item_sk&#xa;      FROM cross_items&#xa;    )&#xa;    AND ss_item_sk = i_item_sk&#xa;    AND ss_sold_date_sk = d_date_sk&#xa;    AND d_week_seq = (&#xa;      SELECT&#xa;        d_week_seq&#xa;      FROM date_dim&#xa;      WHERE&#xa;        d_year = 1999 + 1 AND d_moy = 12 AND d_dom = 22&#xa;    )&#xa;  GROUP BY&#xa;    i_brand_id,&#xa;    i_class_id,&#xa;    i_category_id&#xa;  HAVING&#xa;    SUM(ss_quantity * ss_list_price) &gt; (&#xa;      SELECT&#xa;        average_sales&#xa;      FROM avg_sales&#xa;    )&#xa;) AS this_year, (&#xa;  SELECT&#xa;    &apos;store&apos; AS channel,&#xa;    i_brand_id AS i_brand_id,&#xa;    i_class_id AS i_class_id,&#xa;    i_category_id AS i_category_id,&#xa;    SUM(ss_quantity * ss_list_price) AS sales,&#xa;    COUNT(*) AS number_sales&#xa;  FROM store_sales, item, date_dim&#xa;  WHERE&#xa;    ss_item_sk IN (&#xa;      SELECT&#xa;        ss_item_sk&#xa;      FROM cross_items&#xa;    )&#xa;    AND ss_item_sk = i_item_sk&#xa;    AND ss_sold_date_sk = d_date_sk&#xa;    AND d_week_seq = (&#xa;      SELECT&#xa;        d_week_seq&#xa;      FROM date_dim&#xa;      WHERE&#xa;        d_year = 1999 AND d_moy = 12 AND d_dom = 22&#xa;    )&#xa;  GROUP BY&#xa;    i_brand_id,&#xa;    i_class_id,&#xa;    i_category_id&#xa;  HAVING&#xa;    SUM(ss_quantity * ss_list_price) &gt; (&#xa;      SELECT&#xa;        average_sales&#xa;      FROM avg_sales&#xa;    )&#xa;) AS last_year&#xa;WHERE&#xa;  this_year.i_brand_id = last_year.i_brand_id&#xa;  AND this_year.i_class_id = last_year.i_class_id&#xa;  AND this_year.i_category_id = last_year.i_category_id&#xa;ORDER BY&#xa;  this_year.channel,&#xa;  this_year.i_brand_id,&#xa;  this_year.i_class_id,&#xa;  this_year.i_category_id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="1060.78" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF6FCC95D0CEBC579" QueryPlanHash="0x4167356DE167C4B9" 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="1960" CompileTime="706" CompileCPU="706" CompileMemory="42792"><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:33:26.62" ModificationCount="0" SamplingPercent="26.5691" Statistics="[_WA_Sys_0000000A_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:48.75" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_05D8E0BE]" Table="[store_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:33:29.70" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000015_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:32.21" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000015_03F0984C]" Table="[web_sales]" 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:33:26.43" ModificationCount="0" SamplingPercent="26.4519" Statistics="[_WA_Sys_0000000C_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:30.78" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000013_04E4BC85]" Table="[catalog_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: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:31:24.55" ModificationCount="0" SamplingPercent="74.005" Statistics="[_WA_Sys_00000005_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:44.54" ModificationCount="0" SamplingPercent="73.9834" Statistics="[_WA_Sys_0000000A_70DDC3D8]" Table="[date_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:33:31.43" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000013_03F0984C]" Table="[web_sales]" 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: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:33:28.48" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1.2e-06" AvgRowSize="84" EstimatedTotalSubtreeCost="1060.78" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1083"></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_class_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_class_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_category_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="[Expr1023]"><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="[Expr1024]"><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1041"></ColumnReference><ScalarOperator ScalarString="[Expr1041]"><Identifier><ColumnReference Column="Expr1041"></ColumnReference></Identifier></ScalarOperator></DefinedValue><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_class_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_class_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_category_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="[Expr1065]"><Identifier><ColumnReference Column="Expr1065"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1066"></ColumnReference><ScalarOperator ScalarString="[Expr1066]"><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1083"></ColumnReference><ScalarOperator ScalarString="[Expr1083]"><Identifier><ColumnReference Column="Expr1083"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1.2e-06" AvgRowSize="84" EstimatedTotalSubtreeCost="1060.78" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="84" EstimatedTotalSubtreeCost="1060.78" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1041"></ColumnReference><ScalarOperator ScalarString="&apos;store&apos;"><Const ConstValue="&apos;store&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1083"></ColumnReference><ScalarOperator ScalarString="&apos;store&apos;"><Const ConstValue="&apos;store&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000305577" AvgRowSize="74" EstimatedTotalSubtreeCost="1060.78" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></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]" Column="i_brand_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0.023125" EstimateCPU="0.00021" AvgRowSize="74" EstimatedTotalSubtreeCost="1060.77" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="8" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.000402188" EstimateCPU="7.64431e-05" AvgRowSize="74" EstimatedTotalSubtreeCost="1060.74" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></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]" Column="i_brand_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="446.666" EstimateIO="0" EstimateCPU="0.00193962" AvgRowSize="74" EstimatedTotalSubtreeCost="1060.74" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1108"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1109"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1065]&gt;[Expr1081] AND [Expr1108]=[Expr1109]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1065"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1081"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1108"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1109"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="28" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1081"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="24" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1081"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1081"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1105]=(0) THEN NULL ELSE [globalagg1107]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1105],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1105"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1107"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1105"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="32" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1105"></ColumnReference><ColumnReference Column="globalagg1107"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1105"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1104])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1104"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1107"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1106])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1106"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="14" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="32" EstimatedTotalSubtreeCost="257.297" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1104"></ColumnReference><ColumnReference Column="partialagg1106"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.20273" AvgRowSize="32" EstimatedTotalSubtreeCost="257.263" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1104"></ColumnReference><ColumnReference Column="partialagg1106"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1104"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1106"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1375])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1375"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.81337e+08" EstimateIO="0" EstimateCPU="0.200955" AvgRowSize="16" EstimatedTotalSubtreeCost="257.061" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1375"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1375"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[Union1079],0)*[Union1080]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2.81337e+08" EstimateIO="0" EstimateCPU="0.200955" AvgRowSize="16" EstimatedTotalSubtreeCost="256.86" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Union1080"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.55875e+08" EstimateIO="0" EstimateCPU="20.6177" AvgRowSize="16" EstimatedTotalSubtreeCost="145.905" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1369"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="19" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65462e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="2.2611" AvgRowSize="20" EstimatedTotalSubtreeCost="106.349" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="6" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.32473e+07" EstimateIO="0" EstimateCPU="11.0457" AvgRowSize="16" EstimatedTotalSubtreeCost="73.8008" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1371"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="23" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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="9" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42789e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="52.1084" EstimateCPU="1.13192" AvgRowSize="20" EstimatedTotalSubtreeCost="53.2403" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="4" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.22148e+07" EstimateIO="0" EstimateCPU="5.58587" AvgRowSize="16" EstimatedTotalSubtreeCost="36.9527" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1373"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="27" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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="10" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18938e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="26.0171" EstimateCPU="0.565131" AvgRowSize="20" EstimatedTotalSubtreeCost="26.5823" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="4" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Concat></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="30" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1488.89" EstimateIO="0" EstimateCPU="1.06349e-06" AvgRowSize="78" EstimatedTotalSubtreeCost="803.439" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1488.89" EstimateIO="0" EstimateCPU="0.00404821" AvgRowSize="74" EstimatedTotalSubtreeCost="803.439" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap2469"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><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><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7140.39" EstimateIO="0" EstimateCPU="0.00437789" AvgRowSize="40" EstimatedTotalSubtreeCost="530.373" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1108"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1109"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1023]&gt;[Expr1039] AND [Expr1108]=[Expr1109]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1039"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1108"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1109"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="33" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="28" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1039"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="35" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="24" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1039"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1039"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1101]=(0) THEN NULL ELSE [globalagg1103]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1101],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1101"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1103"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1101"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="36" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="32" EstimatedTotalSubtreeCost="257.298" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1101"></ColumnReference><ColumnReference Column="globalagg1103"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1101"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1100])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1100"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1103"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1102])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1102"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="37" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="32" EstimatedTotalSubtreeCost="257.297" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1100"></ColumnReference><ColumnReference Column="partialagg1102"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.20273" AvgRowSize="32" EstimatedTotalSubtreeCost="257.263" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1100"></ColumnReference><ColumnReference Column="partialagg1102"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1100"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1102"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1388])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1388"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="39" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.81337e+08" EstimateIO="0" EstimateCPU="0.200955" AvgRowSize="16" EstimatedTotalSubtreeCost="257.061" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1388"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1388"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[Union1037],0)*[Union1038]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1037"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1038"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="40" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2.81337e+08" EstimateIO="0" EstimateCPU="0.200955" AvgRowSize="16" EstimatedTotalSubtreeCost="256.86" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Column="Union1038"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1038"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.55875e+08" EstimateIO="0" EstimateCPU="20.6177" AvgRowSize="16" EstimatedTotalSubtreeCost="145.905" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1378"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="42" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="43" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="44" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65462e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="2.2611" AvgRowSize="20" EstimatedTotalSubtreeCost="106.349" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="3" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="45" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.32473e+07" EstimateIO="0" EstimateCPU="11.0457" AvgRowSize="16" EstimatedTotalSubtreeCost="73.8008" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1380"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="46" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="47" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="48" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42789e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="52.1084" EstimateCPU="1.13192" AvgRowSize="20" EstimatedTotalSubtreeCost="53.2403" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="2" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="49" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.22148e+07" EstimateIO="0" EstimateCPU="5.58587" AvgRowSize="16" EstimatedTotalSubtreeCost="36.9527" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1382"></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><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="50" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="51" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="52" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18938e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="26.0171" EstimateCPU="0.565131" AvgRowSize="20" EstimatedTotalSubtreeCost="26.5823" 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_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_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_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="2" 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_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_list_price] 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_quantity"></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_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Concat></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="53" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23801.3" EstimateIO="0" EstimateCPU="1.70009e-05" AvgRowSize="44" EstimatedTotalSubtreeCost="273.07" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="54" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23801.3" EstimateIO="0" EstimateCPU="0" AvgRowSize="40" EstimatedTotalSubtreeCost="273.07" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2489]=(0) THEN NULL ELSE [Expr2490] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2489"></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="Expr2490"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr2491],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr2491"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="55" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="23801.3" EstimateIO="0" EstimateCPU="0.0110964" AvgRowSize="40" EstimatedTotalSubtreeCost="273.07" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr2489"></ColumnReference><ColumnReference Column="Expr2490"></ColumnReference><ColumnReference Column="Expr2491"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr2489"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1088])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2490"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1088])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2491"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><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><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="56" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="26913.5" EstimateIO="0.102531" EstimateCPU="0.00403703" AvgRowSize="28" EstimatedTotalSubtreeCost="273.059" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="57" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="26913.5" EstimateIO="0" EstimateCPU="0.00632134" AvgRowSize="28" EstimatedTotalSubtreeCost="272.904" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1538"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1085"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1085]=[TPCDS_SF100].[dbo].[date_dim].[d_week_seq]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1085"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="58" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1" EstimateIO="0.396918" EstimateCPU="2.31e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.649418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1085"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="OneToMany"><RelOp NodeId="59" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="2.48e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0749085" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1085"></ColumnReference></OutputList><Assert StartupExpression="0"><RelOp NodeId="60" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0749061" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1084"></ColumnReference><ColumnReference Column="Expr1085"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1084"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1090])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1090"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1085"></ColumnReference><ScalarOperator ScalarString="ANY([partialagg1091])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="partialagg1091"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="61" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="0.073131" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1090"></ColumnReference><ColumnReference Column="partialagg1091"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="62" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00177518" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0400017" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1090"></ColumnReference><ColumnReference Column="partialagg1091"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1090"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1091"></ColumnReference><ScalarOperator ScalarString="ANY([TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="63" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="35.6739" EstimatedRowsRead="73239" EstimateIO="0.0328475" EstimateCPU="0.000576571" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0334241" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></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_week_seq"></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_year]=(2000) AND [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) AND [TPCDS_SF100].[dbo].[date_dim].[d_dom]=(22)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2000)"></Const></ScalarOperator></Compare></ScalarOperator><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_dom"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(22)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1084]&gt;(1) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1084"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Move></RelOp><RelOp NodeId="64" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="26913.5" EstimateIO="0" EstimateCPU="0.00554331" AvgRowSize="32" EstimatedTotalSubtreeCost="272.248" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1532"></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="65" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="7.02121" EstimateIO="0.396918" EstimateCPU="3.97746e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.597354" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="67" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.02121" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></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_week_seq] IS NOT NULL AND PROBE([Opt_Bitmap1538],[TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1538"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="68" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="27225.1" EstimateIO="0" EstimateCPU="0.0101262" AvgRowSize="32" EstimatedTotalSubtreeCost="271.646" 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="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1527"></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="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="69" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="27123" EstimateIO="0.822277" EstimateCPU="0.00520148" AvgRowSize="36" EstimatedTotalSubtreeCost="128.493" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="70" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="27123" EstimateIO="0" EstimateCPU="0.0086139" AvgRowSize="36" EstimatedTotalSubtreeCost="127.286" 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="[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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1432"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="71" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="26352.6" EstimateIO="0" EstimateCPU="2.39682e-05" AvgRowSize="24" EstimatedTotalSubtreeCost="127.167" 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_item_sk"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="73" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="26352.6" EstimatedRowsRead="2.87777e+08" EstimateIO="124.905" EstimateCPU="2.2611" AvgRowSize="24" EstimatedTotalSubtreeCost="127.167" 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_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND PROBE([Opt_Bitmap1532],[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk])"><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><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1532"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="74" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><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_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></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_class_id"></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_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="75" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="193861" EstimateIO="0" EstimateCPU="0.00177928" AvgRowSize="11" EstimatedTotalSubtreeCost="143.142" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="76" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="204930" EstimateIO="0.023125" EstimateCPU="3.75237e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="143.141" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="77" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="204930" EstimateIO="0" EstimateCPU="0.00178313" AvgRowSize="11" EstimatedTotalSubtreeCost="143.108" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1517"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><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]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="78" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="203388" EstimateIO="0.396918" EstimateCPU="2.47242e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.663493" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="79" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.00160656" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0889797" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></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_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></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_class_id"></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_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="80" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="115011" EstimateIO="0" EstimateCPU="0.00177964" AvgRowSize="19" EstimatedTotalSubtreeCost="142.442" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1502"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="81" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="115011" EstimateIO="0" EstimateCPU="0.00177979" AvgRowSize="19" EstimatedTotalSubtreeCost="101.429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1485"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="82" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="124642" EstimateIO="0" EstimateCPU="0.00202577" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="83" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="4.3257e+07" EstimateIO="0.023125" EstimateCPU="0.00079206" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2969" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="84" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.3257e+07" EstimateIO="0" EstimateCPU="0.00238645" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2629" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1463"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="85" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[iws]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="86" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.22227e+07" EstimateIO="0" EstimateCPU="0.00351241" AvgRowSize="11" EstimatedTotalSubtreeCost="20.1506" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1466"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d3].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="87" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="88" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" 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]" Alias="[d3]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d3]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d3].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d3].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="89" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.19072e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="19.5134" EstimateCPU="0.565131" AvgRowSize="15" EstimatedTotalSubtreeCost="20.0786" 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_item_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="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp><RelOp NodeId="90" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="115012" EstimateIO="0" EstimateCPU="0.00178024" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5538" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="91" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="230024" EstimateIO="0.023125" EstimateCPU="4.21186e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5521" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="92" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="230024" EstimateIO="0" EstimateCPU="0.00272958" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="93" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.66128e+08" EstimateIO="0" EstimateCPU="0.0040112" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5162" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1477"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="94" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[iss]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></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]" Alias="[iss]" Column="i_class_id"></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]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="95" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.61409e+08" EstimateIO="0" EstimateCPU="0.00543657" AvgRowSize="11" EstimatedTotalSubtreeCost="80.4023" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1480"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d1].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="96" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="97" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" 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]" Alias="[d1]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d1]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d1].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d1].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="98" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.74886e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="78.0668" EstimateCPU="2.2611" AvgRowSize="15" EstimatedTotalSubtreeCost="80.3279" 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_item_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="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="99" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="124642" EstimateIO="0" EstimateCPU="0.00178068" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4367" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="100" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="249285" EstimateIO="0.023125" EstimateCPU="4.56454e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="101" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="249285" EstimateIO="0" EstimateCPU="0.00227551" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4018" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="102" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.63335e+07" EstimateIO="0" EstimateCPU="0.00295441" AvgRowSize="19" EstimatedTotalSubtreeCost="40.3995" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1496"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="103" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[ics]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="104" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.35601e+07" EstimateIO="0" EstimateCPU="0.00418383" AvgRowSize="11" EstimatedTotalSubtreeCost="40.2866" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1499"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d2].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="105" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="106" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" 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]" Alias="[d2]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d2]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d2].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d2].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="107" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.43326e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="39.0819" EstimateCPU="1.13192" AvgRowSize="15" EstimatedTotalSubtreeCost="40.2138" 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_item_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="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="108" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23801.3" EstimateIO="0" EstimateCPU="0" AvgRowSize="40" EstimatedTotalSubtreeCost="273.062" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2492]=(0) THEN NULL ELSE [Expr2493] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2492"></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="Expr2493"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1066"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr2494],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr2494"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="109" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="23801.3" EstimateIO="0" EstimateCPU="0.00235759" AvgRowSize="40" EstimatedTotalSubtreeCost="273.062" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr2492"></ColumnReference><ColumnReference Column="Expr2493"></ColumnReference><ColumnReference Column="Expr2494"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr2492"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1089])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2493"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1089])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2494"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><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><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="110" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="26913.5" EstimateIO="0.102531" EstimateCPU="0.00403703" AvgRowSize="28" EstimatedTotalSubtreeCost="273.059" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="111" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="26913.5" EstimateIO="0" EstimateCPU="0.00632134" AvgRowSize="28" EstimatedTotalSubtreeCost="272.904" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1727"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1087"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1087]=[TPCDS_SF100].[dbo].[date_dim].[d_week_seq]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1087"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="112" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1" EstimateIO="0.396918" EstimateCPU="2.31e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.649418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1087"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="OneToMany"><RelOp NodeId="113" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="2.48e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0749085" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1087"></ColumnReference></OutputList><Assert StartupExpression="0"><RelOp NodeId="114" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0749061" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1086"></ColumnReference><ColumnReference Column="Expr1087"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1086"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1095])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1095"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1087"></ColumnReference><ScalarOperator ScalarString="ANY([partialagg1096])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="partialagg1096"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="115" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="0.073131" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1095"></ColumnReference><ColumnReference Column="partialagg1096"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="116" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00177518" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0400017" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1095"></ColumnReference><ColumnReference Column="partialagg1096"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1095"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1096"></ColumnReference><ScalarOperator ScalarString="ANY([TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="117" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="34.5869" EstimatedRowsRead="73239" EstimateIO="0.0328475" EstimateCPU="0.000576571" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0334241" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></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_week_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) AND [TPCDS_SF100].[dbo].[date_dim].[d_dom]=(22)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><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_dom"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(22)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1086]&gt;(1) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1086"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Move></RelOp><RelOp NodeId="118" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="26913.5" EstimateIO="0" EstimateCPU="0.00554331" AvgRowSize="32" EstimatedTotalSubtreeCost="272.248" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1721"></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="119" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="7.02121" EstimateIO="0.396918" EstimateCPU="3.97746e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.597354" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="121" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.02121" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] IS NOT NULL AND PROBE([Opt_Bitmap1727],[TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1727"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="122" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="27225.1" EstimateIO="0" EstimateCPU="0.0101262" AvgRowSize="32" EstimatedTotalSubtreeCost="271.646" 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="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1638"></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="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="123" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="27123" EstimateIO="0.822277" EstimateCPU="0.00520148" AvgRowSize="36" EstimatedTotalSubtreeCost="128.493" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="124" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="27123" EstimateIO="0" EstimateCPU="0.0086139" AvgRowSize="36" EstimatedTotalSubtreeCost="127.286" 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="[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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1614"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="125" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="26352.6" EstimateIO="0" EstimateCPU="2.39682e-05" AvgRowSize="24" EstimatedTotalSubtreeCost="127.167" 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_item_sk"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="127" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="26352.6" EstimatedRowsRead="2.87777e+08" EstimateIO="124.905" EstimateCPU="2.2611" AvgRowSize="24" EstimatedTotalSubtreeCost="127.167" 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_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND PROBE([Opt_Bitmap1721],[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk])"><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><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1721"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="128" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><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_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></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_class_id"></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_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="129" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="193861" EstimateIO="0" EstimateCPU="0.00177928" AvgRowSize="11" EstimatedTotalSubtreeCost="143.142" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="130" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="204930" EstimateIO="0.023125" EstimateCPU="3.75237e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="143.141" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="131" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="204930" EstimateIO="0" EstimateCPU="0.00178313" AvgRowSize="11" EstimatedTotalSubtreeCost="143.108" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1646"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><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]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="132" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="203388" EstimateIO="0.396918" EstimateCPU="2.47242e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.663493" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="133" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.00160656" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0889797" 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_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></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_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></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_class_id"></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_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="134" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="115011" EstimateIO="0" EstimateCPU="0.00177964" AvgRowSize="19" EstimatedTotalSubtreeCost="142.442" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1701"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="135" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="115011" EstimateIO="0" EstimateCPU="0.00177979" AvgRowSize="19" EstimatedTotalSubtreeCost="101.429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1685"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id]=[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id]=[TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]=[TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="136" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="124642" EstimateIO="0" EstimateCPU="0.00202577" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iws].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iws].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iws].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="137" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="4.3257e+07" EstimateIO="0.023125" EstimateCPU="0.00079206" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2969" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="138" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.3257e+07" EstimateIO="0" EstimateCPU="0.00238645" AvgRowSize="19" EstimatedTotalSubtreeCost="20.2629" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1659"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="139" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iws]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[iws]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="140" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.22227e+07" EstimateIO="0" EstimateCPU="0.00351241" AvgRowSize="11" EstimatedTotalSubtreeCost="20.1506" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1663"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d3].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="141" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="142" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" 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]" Alias="[d3]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d3]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d3].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d3].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d3]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="143" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.19072e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="19.5134" EstimateCPU="0.565131" AvgRowSize="15" EstimatedTotalSubtreeCost="20.0786" 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_item_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="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp><RelOp NodeId="144" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="115012" EstimateIO="0" EstimateCPU="0.00178024" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5538" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="145" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="230024" EstimateIO="0.023125" EstimateCPU="4.21186e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5521" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="146" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="230024" EstimateIO="0" EstimateCPU="0.00272958" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="147" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.66128e+08" EstimateIO="0" EstimateCPU="0.0040112" AvgRowSize="19" EstimatedTotalSubtreeCost="80.5162" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1670"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="148" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203388" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[iss]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [iss].[i_brand_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [iss].[i_class_id] IS NOT NULL AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [iss].[i_category_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[iss]" Column="i_brand_id"></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]" Alias="[iss]" Column="i_class_id"></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]" Alias="[iss]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="149" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.61409e+08" EstimateIO="0" EstimateCPU="0.00543657" AvgRowSize="11" EstimatedTotalSubtreeCost="80.4023" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1674"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d1].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="150" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="151" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" 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]" Alias="[d1]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d1]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d1].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d1].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d1]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="152" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.74886e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="78.0668" EstimateCPU="2.2611" AvgRowSize="15" EstimatedTotalSubtreeCost="80.3279" 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_item_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="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="153" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="124642" EstimateIO="0" EstimateCPU="0.00178068" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4367" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="154" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="249285" EstimateIO="0.023125" EstimateCPU="4.56454e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></DistributionKey><RelOp NodeId="155" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="249285" EstimateIO="0" EstimateCPU="0.00227551" AvgRowSize="19" EstimatedTotalSubtreeCost="40.4018" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] = [TPCDS_SF100].[dbo].[item].[i_brand_id] as [ics].[i_brand_id] AND [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] = [TPCDS_SF100].[dbo].[item].[i_class_id] as [ics].[i_class_id] AND [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id] = [TPCDS_SF100].[dbo].[item].[i_category_id] as [ics].[i_category_id]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="156" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.63335e+07" EstimateIO="0" EstimateCPU="0.00295441" AvgRowSize="19" EstimatedTotalSubtreeCost="40.3995" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1692"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="157" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.0873731" EstimateCPU="0.0224918" AvgRowSize="23" EstimatedTotalSubtreeCost="0.109865" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Alias="[ics]" Column="i_category_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" Alias="[ics]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="158" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.35601e+07" EstimateIO="0" EstimateCPU="0.00418383" AvgRowSize="11" EstimatedTotalSubtreeCost="40.2866" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1696"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk] as [d2].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="159" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1082.83" EstimateIO="0.0295964" EstimateCPU="0.00227394" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0683054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="160" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1082.83" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.000576571" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0228282" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" 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]" Alias="[d2]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d2]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year] as [d2].[d_year]&gt;=(1999) AND [TPCDS_SF100].[dbo].[date_dim].[d_year] as [d2].[d_year]&lt;=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d2]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="161" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.43326e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="39.0819" EstimateCPU="1.13192" AvgRowSize="15" EstimatedTotalSubtreeCost="40.2138" 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_item_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="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL"><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></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></TopSort></RelOp></ComputeScalar></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
