<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH ssr AS (&#xa;  SELECT&#xa;    s_store_id AS s_store_id,&#xa;    SUM(sales_price) AS sales,&#xa;    SUM(profit) AS profit,&#xa;    SUM(return_amt) AS returns,&#xa;    SUM(net_loss) AS profit_loss&#xa;  FROM (&#xa;    SELECT&#xa;      ss_store_sk AS store_sk,&#xa;      ss_sold_date_sk AS date_sk,&#xa;      ss_ext_sales_price AS sales_price,&#xa;      ss_net_profit AS profit,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS return_amt,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS net_loss&#xa;    FROM store_sales&#xa;    UNION ALL&#xa;    SELECT&#xa;      sr_store_sk AS store_sk,&#xa;      sr_returned_date_sk AS date_sk,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS sales_price,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS profit,&#xa;      sr_return_amt AS return_amt,&#xa;      sr_net_loss AS net_loss&#xa;    FROM store_returns&#xa;  ) AS salesreturns, date_dim, store&#xa;  WHERE&#xa;    date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2000-08-19&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 14, CAST(&apos;2000-08-19&apos; AS DATE))&#xa;    )&#xa;    AND store_sk = s_store_sk&#xa;  GROUP BY&#xa;    s_store_id&#xa;), csr AS (&#xa;  SELECT&#xa;    cp_catalog_page_id AS cp_catalog_page_id,&#xa;    SUM(sales_price) AS sales,&#xa;    SUM(profit) AS profit,&#xa;    SUM(return_amt) AS returns,&#xa;    SUM(net_loss) AS profit_loss&#xa;  FROM (&#xa;    SELECT&#xa;      cs_catalog_page_sk AS page_sk,&#xa;      cs_sold_date_sk AS date_sk,&#xa;      cs_ext_sales_price AS sales_price,&#xa;      cs_net_profit AS profit,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS return_amt,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS net_loss&#xa;    FROM catalog_sales&#xa;    UNION ALL&#xa;    SELECT&#xa;      cr_catalog_page_sk AS page_sk,&#xa;      cr_returned_date_sk AS date_sk,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS sales_price,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS profit,&#xa;      cr_return_amount AS return_amt,&#xa;      cr_net_loss AS net_loss&#xa;    FROM catalog_returns&#xa;  ) AS salesreturns, date_dim, catalog_page&#xa;  WHERE&#xa;    date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2000-08-19&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 14, CAST(&apos;2000-08-19&apos; AS DATE))&#xa;    )&#xa;    AND page_sk = cp_catalog_page_sk&#xa;  GROUP BY&#xa;    cp_catalog_page_id&#xa;), wsr AS (&#xa;  SELECT&#xa;    web_site_id AS web_site_id,&#xa;    SUM(sales_price) AS sales,&#xa;    SUM(profit) AS profit,&#xa;    SUM(return_amt) AS returns,&#xa;    SUM(net_loss) AS profit_loss&#xa;  FROM (&#xa;    SELECT&#xa;      ws_web_site_sk AS wsr_web_site_sk,&#xa;      ws_sold_date_sk AS date_sk,&#xa;      ws_ext_sales_price AS sales_price,&#xa;      ws_net_profit AS profit,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS return_amt,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS net_loss&#xa;    FROM web_sales&#xa;    UNION ALL&#xa;    SELECT&#xa;      ws_web_site_sk AS wsr_web_site_sk,&#xa;      wr_returned_date_sk AS date_sk,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS sales_price,&#xa;      CAST(0 AS DECIMAL(7, 2)) AS profit,&#xa;      wr_return_amt AS return_amt,&#xa;      wr_net_loss AS net_loss&#xa;    FROM web_returns&#xa;    LEFT OUTER JOIN web_sales&#xa;      ON (&#xa;        wr_item_sk = ws_item_sk AND wr_order_number = ws_order_number&#xa;      )&#xa;  ) AS salesreturns, date_dim, web_site&#xa;  WHERE&#xa;    date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2000-08-19&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 14, CAST(&apos;2000-08-19&apos; AS DATE))&#xa;    )&#xa;    AND wsr_web_site_sk = web_site_sk&#xa;  GROUP BY&#xa;    web_site_id&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  channel,&#xa;  id,&#xa;  SUM(sales) AS sales,&#xa;  SUM(returns) AS returns,&#xa;  SUM(profit) AS profit&#xa;FROM (&#xa;  SELECT&#xa;    &apos;store channel&apos; AS channel,&#xa;    &apos;store&apos; + s_store_id AS id,&#xa;    sales,&#xa;    returns,&#xa;    (&#xa;      profit - profit_loss&#xa;    ) AS profit&#xa;  FROM ssr&#xa;  UNION ALL&#xa;  SELECT&#xa;    &apos;catalog channel&apos; AS channel,&#xa;    &apos;catalog_page&apos; + cp_catalog_page_id AS id,&#xa;    sales,&#xa;    returns,&#xa;    (&#xa;      profit - profit_loss&#xa;    ) AS profit&#xa;  FROM csr&#xa;  UNION ALL&#xa;  SELECT&#xa;    &apos;web channel&apos; AS channel,&#xa;    &apos;web_site&apos; + web_site_id AS id,&#xa;    sales,&#xa;    returns,&#xa;    (&#xa;      profit - profit_loss&#xa;    ) AS profit&#xa;  FROM wsr&#xa;) AS x&#xa;GROUP BY&#xa;  ROLLUP (&#xa;    channel,&#xa;    id&#xa;  )&#xa;ORDER BY&#xa;  channel,&#xa;  id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="355.057" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x716360150A5405FE" QueryPlanHash="0xEC41ED9FA281B36D" 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="736" CompileTime="101" CompileCPU="101" CompileMemory="11768"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:32:27.33" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_02084FDA]" Table="[catalog_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:02.15" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:27.69" ModificationCount="0" SamplingPercent="92.992" Statistics="[_WA_Sys_00000002_7F2BE32F]" Table="[catalog_page]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.21" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:26.98" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:27.99" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:40.44" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:22.76" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_07C12930]" Table="[store]" 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:42:33.60" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_07C12930]" Table="[store]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:28.33" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:29.24" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:25.98" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02084FDA]" Table="[catalog_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:02.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_7B5B524B]" Table="[store_returns]" 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:24:42.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_7A672E12]" Table="[web_site]" 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:24:42.45" ModificationCount="0" SamplingPercent="73.9544" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:27.52" ModificationCount="0" SamplingPercent="92.9897" Statistics="[_WA_Sys_00000001_7F2BE32F]" Table="[catalog_page]" 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:14.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_05D8E0BE]" Table="[store_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:41.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="85" EstimatedTotalSubtreeCost="355.057" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1077"></ColumnReference><ScalarOperator ScalarString="[Union1077]"><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1078"></ColumnReference><ScalarOperator ScalarString="[Union1078]"><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1082"></ColumnReference><ScalarOperator ScalarString="[Expr1082]"><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1083"></ColumnReference><ScalarOperator ScalarString="[Expr1083]"><Identifier><ColumnReference Column="Expr1083"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1084"></ColumnReference><ScalarOperator ScalarString="[Expr1084]"><Identifier><ColumnReference Column="Expr1084"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="85" EstimatedTotalSubtreeCost="355.057" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.145674" AvgRowSize="85" EstimatedTotalSubtreeCost="355.057" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Union1077"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1078"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15213.6" EstimateIO="0" EstimateCPU="0" AvgRowSize="85" EstimatedTotalSubtreeCost="354.906" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1082"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1174]=(0) THEN NULL ELSE [Expr1175] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1174"></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="Expr1175"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1083"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1176]=(0) THEN NULL ELSE [Expr1177] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1176"></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="Expr1177"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1084"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1178]=(0) THEN NULL ELSE [Expr1179] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1178"></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="Expr1179"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="15213.6" EstimateIO="0" EstimateCPU="0.142837" AvgRowSize="85" EstimatedTotalSubtreeCost="354.906" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference><ColumnReference Column="Expr1174"></ColumnReference><ColumnReference Column="Expr1175"></ColumnReference><ColumnReference Column="Expr1176"></ColumnReference><ColumnReference Column="Expr1177"></ColumnReference><ColumnReference Column="Expr1178"></ColumnReference><ColumnReference Column="Expr1179"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1174"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1086])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1175"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1086])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1176"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1087])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1087"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1177"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1087])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1087"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1178"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1088])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1179"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1088])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference><ColumnReference Column="Expr1085"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1089] = [Expr1089] AND [Expr1090] = [Expr1090] AND [Expr1085] = [Expr1085]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1090"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1090"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1085"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1085"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="44155.6" EstimateIO="0" EstimateCPU="0.000441556" AvgRowSize="89" EstimatedTotalSubtreeCost="354.763" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1085"></ColumnReference><ColumnReference Column="partialagg1086"></ColumnReference><ColumnReference Column="partialagg1087"></ColumnReference><ColumnReference Column="partialagg1088"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1085]&amp;(1))=(0) THEN [Union1077] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1085"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1090"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1085]&amp;(2))=(0) THEN [Union1078] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1085"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="44155.6" EstimateIO="0" EstimateCPU="0.0124097" AvgRowSize="102" EstimatedTotalSubtreeCost="354.762" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1085"></ColumnReference><ColumnReference Column="partialagg1086"></ColumnReference><ColumnReference Column="partialagg1087"></ColumnReference><ColumnReference Column="partialagg1088"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1118"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1119"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1118]=[Expr1119]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1118"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1119"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="3.793e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1085"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1118"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="3" EstimateIO="0" EstimateCPU="3.157e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="3.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1085"></ColumnReference></OutputList><ConstantScan><Values><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="14718.5" EstimateIO="0" EstimateCPU="0.000147185" AvgRowSize="102" EstimatedTotalSubtreeCost="354.75" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="partialagg1086"></ColumnReference><ColumnReference Column="partialagg1087"></ColumnReference><ColumnReference Column="partialagg1088"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1119"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="14718.5" EstimateIO="0" EstimateCPU="0" AvgRowSize="98" EstimatedTotalSubtreeCost="354.75" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="partialagg1086"></ColumnReference><ColumnReference Column="partialagg1087"></ColumnReference><ColumnReference Column="partialagg1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1086"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1168]=(0) THEN NULL ELSE [Expr1169] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1168"></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="Expr1169"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1087"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1170]=(0) THEN NULL ELSE [Expr1171] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1170"></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="Expr1171"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1088"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1172]=(0) THEN NULL ELSE [Expr1173] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1172"></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="Expr1173"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="14718.5" EstimateIO="0" EstimateCPU="0.124077" AvgRowSize="98" EstimatedTotalSubtreeCost="354.75" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1168"></ColumnReference><ColumnReference Column="Expr1169"></ColumnReference><ColumnReference Column="Expr1170"></ColumnReference><ColumnReference Column="Expr1171"></ColumnReference><ColumnReference Column="Expr1172"></ColumnReference><ColumnReference Column="Expr1173"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1168"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1079])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1169"></ColumnReference><ScalarOperator ScalarString="SUM([Union1079])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1170"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1080])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1171"></ColumnReference><ScalarOperator ScalarString="SUM([Union1080])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1172"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1081])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1081"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1173"></ColumnReference><ScalarOperator ScalarString="SUM([Union1081])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1081"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1077] = [Union1077] AND [Union1078] = [Union1078]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="15" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="14733.2" EstimateIO="0" EstimateCPU="0.000147332" AvgRowSize="98" EstimatedTotalSubtreeCost="354.626" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Column="Union1081"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1074"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1075"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1081"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="142.479" EstimateIO="0" EstimateCPU="1.42479e-06" AvgRowSize="91" EstimatedTotalSubtreeCost="183.066" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="&apos;store channel&apos;"><Const ConstValue="&apos;store channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="&apos;store&apos;+[TPCDS_SF100].[dbo].[store].[s_store_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;store&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="[Expr1019]-[Expr1021]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="142.479" EstimateIO="0" EstimateCPU="0" AvgRowSize="95" EstimatedTotalSubtreeCost="183.066" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1144]=(0) THEN NULL ELSE [Expr1145] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1144"></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="Expr1145"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1146]=(0) THEN NULL ELSE [Expr1147] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1146"></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="Expr1147"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1148]=(0) THEN NULL ELSE [Expr1149] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1148"></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="Expr1149"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1150]=(0) THEN NULL ELSE [Expr1151] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1150"></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="Expr1151"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="142.479" EstimateIO="0" EstimateCPU="1.45196" AvgRowSize="95" EstimatedTotalSubtreeCost="183.066" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1144"></ColumnReference><ColumnReference Column="Expr1145"></ColumnReference><ColumnReference Column="Expr1146"></ColumnReference><ColumnReference Column="Expr1147"></ColumnReference><ColumnReference Column="Expr1148"></ColumnReference><ColumnReference Column="Expr1149"></ColumnReference><ColumnReference Column="Expr1150"></ColumnReference><ColumnReference Column="Expr1151"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1144"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1010])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1145"></ColumnReference><ScalarOperator ScalarString="SUM([Union1010])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1146"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1011])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1147"></ColumnReference><ScalarOperator ScalarString="SUM([Union1011])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1148"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1012])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1012"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1149"></ColumnReference><ScalarOperator ScalarString="SUM([Union1012])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1012"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1150"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1013])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1013"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1151"></ColumnReference><ScalarOperator ScalarString="SUM([Union1013])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1013"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_id] = [TPCDS_SF100].[dbo].[store].[s_store_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.17056e+06" EstimateIO="0" EstimateCPU="1.72393" AvgRowSize="47" EstimatedTotalSubtreeCost="181.614" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Union1011"></ColumnReference><ColumnReference Column="Union1012"></ColumnReference><ColumnReference Column="Union1013"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1008"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1008]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.26988e+06" EstimateIO="0" EstimateCPU="1.86605" AvgRowSize="31" EstimatedTotalSubtreeCost="179.886" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Union1011"></ColumnReference><ColumnReference Column="Union1012"></ColumnReference><ColumnReference Column="Union1013"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1120"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1009"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1009]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1009"></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="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15.2405" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2000-08-19&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-09-02&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-08-19&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-09-02&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="23" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="3.16461e+08" EstimateIO="0" EstimateCPU="0.0247235" AvgRowSize="35" EstimatedTotalSubtreeCost="177.941" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Union1011"></ColumnReference><ColumnReference Column="Union1012"></ColumnReference><ColumnReference Column="Union1013"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1011"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1012"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1013"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.87777e+08" EstimateIO="0" EstimateCPU="0.0224826" AvgRowSize="35" EstimatedTotalSubtreeCost="161.788" 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_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.87777e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="130.11" EstimateCPU="31.6554" AvgRowSize="25" EstimatedTotalSubtreeCost="161.765" 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_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></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_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="26" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.86846e+07" EstimateIO="0" EstimateCPU="0.00224098" AvgRowSize="35" EstimatedTotalSubtreeCost="16.1286" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.86846e+07" EstimatedRowsRead="2.86846e+07" EstimateIO="12.971" EstimateCPU="3.15532" AvgRowSize="25" EstimatedTotalSubtreeCost="16.1263" TableCardinality="2.86846e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></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_returns]" Column="sr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Concat></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="14578.7" EstimateIO="0" EstimateCPU="0.000145787" AvgRowSize="99" EstimatedTotalSubtreeCost="91.912" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1047"></ColumnReference><ScalarOperator ScalarString="&apos;catalog channel&apos;"><Const ConstValue="&apos;catalog channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048"></ColumnReference><ScalarOperator ScalarString="&apos;catalog_page&apos;+[TPCDS_SF100].[dbo].[catalog_page].[cp_catalog_page_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;catalog_page&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1049"></ColumnReference><ScalarOperator ScalarString="[Expr1044]-[Expr1046]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1046"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="14578.7" EstimateIO="0" EstimateCPU="0" AvgRowSize="95" EstimatedTotalSubtreeCost="91.9118" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1152]=(0) THEN NULL ELSE [Expr1153] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1152"></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="Expr1153"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1154]=(0) THEN NULL ELSE [Expr1155] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1154"></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="Expr1155"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1156]=(0) THEN NULL ELSE [Expr1157] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1156"></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="Expr1157"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1046"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1158]=(0) THEN NULL ELSE [Expr1159] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1158"></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="Expr1159"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="14578.7" EstimateIO="0" EstimateCPU="0.828032" AvgRowSize="95" EstimatedTotalSubtreeCost="91.9118" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1152"></ColumnReference><ColumnReference Column="Expr1153"></ColumnReference><ColumnReference Column="Expr1154"></ColumnReference><ColumnReference Column="Expr1155"></ColumnReference><ColumnReference Column="Expr1156"></ColumnReference><ColumnReference Column="Expr1157"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference><ColumnReference Column="Expr1159"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1152"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1035])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1153"></ColumnReference><ScalarOperator ScalarString="SUM([Union1035])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1154"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1036])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1155"></ColumnReference><ScalarOperator ScalarString="SUM([Union1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1156"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1037])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1037"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1157"></ColumnReference><ScalarOperator ScalarString="SUM([Union1037])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1037"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1158"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1038])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1159"></ColumnReference><ScalarOperator ScalarString="SUM([Union1038])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_page].[cp_catalog_page_id] = [TPCDS_SF100].[dbo].[catalog_page].[cp_catalog_page_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.15162e+06" EstimateIO="0" EstimateCPU="0.934003" AvgRowSize="47" EstimatedTotalSubtreeCost="91.0838" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Column="Union1038"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1033"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1033]=[TPCDS_SF100].[dbo].[catalog_page].[cp_catalog_page_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="32" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="20334" EstimatedRowsRead="20334" EstimateIO="0.0137839" EstimateCPU="0.00225244" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0160363" TableCardinality="20334" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_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="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_page]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.1483e+06" EstimateIO="0" EstimateCPU="0.936697" AvgRowSize="31" EstimatedTotalSubtreeCost="90.1337" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Column="Union1038"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1126"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1034"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1034]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1034"></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="34" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15.2405" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2000-08-19&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-09-02&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-08-19&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-09-02&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="35" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="1.58488e+08" EstimateIO="0" EstimateCPU="0.0123819" AvgRowSize="35" EstimatedTotalSubtreeCost="89.1176" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Column="Union1038"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1036"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1037"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1038"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.44063e+08" EstimateIO="0" EstimateCPU="0.0112549" AvgRowSize="35" EstimatedTotalSubtreeCost="80.9931" 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_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="37" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.44063e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="65.1349" EstimateCPU="15.8469" AvgRowSize="25" EstimatedTotalSubtreeCost="80.9818" 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_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></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_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="38" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.44253e+07" EstimateIO="0" EstimateCPU="0.00112698" AvgRowSize="35" EstimatedTotalSubtreeCost="8.11218" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.44253e+07" EstimatedRowsRead="1.44253e+07" EstimateIO="6.52425" EstimateCPU="1.5868" AvgRowSize="25" EstimatedTotalSubtreeCost="8.11105" TableCardinality="1.44253e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_catalog_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></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_returns]" Column="cr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Concat></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="40" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="12" EstimateIO="0" EstimateCPU="1.2e-07" AvgRowSize="93" EstimatedTotalSubtreeCost="79.6482" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference><ColumnReference Column="Expr1074"></ColumnReference><ColumnReference Column="Expr1075"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1074"></ColumnReference><ScalarOperator ScalarString="&apos;web channel&apos;"><Const ConstValue="&apos;web channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1075"></ColumnReference><ScalarOperator ScalarString="&apos;web_site&apos;+[TPCDS_SF100].[dbo].[web_site].[web_site_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;web_site&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1076"></ColumnReference><ScalarOperator ScalarString="[Expr1071]-[Expr1073]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1073"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="12" EstimateIO="0" EstimateCPU="0" AvgRowSize="95" EstimatedTotalSubtreeCost="79.6482" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference><ColumnReference Column="Expr1073"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1070"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1160]=(0) THEN NULL ELSE [Expr1161] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1160"></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="Expr1161"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1162]=(0) THEN NULL ELSE [Expr1163] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1162"></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="Expr1163"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1072"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1164]=(0) THEN NULL ELSE [Expr1165] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1164"></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="Expr1165"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1073"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1166]=(0) THEN NULL ELSE [Expr1167] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1166"></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="Expr1167"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="42" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="12" EstimateIO="0" EstimateCPU="0.369249" AvgRowSize="95" EstimatedTotalSubtreeCost="79.6482" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1160"></ColumnReference><ColumnReference Column="Expr1161"></ColumnReference><ColumnReference Column="Expr1162"></ColumnReference><ColumnReference Column="Expr1163"></ColumnReference><ColumnReference Column="Expr1164"></ColumnReference><ColumnReference Column="Expr1165"></ColumnReference><ColumnReference Column="Expr1166"></ColumnReference><ColumnReference Column="Expr1167"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1160"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1062])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1062"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1161"></ColumnReference><ScalarOperator ScalarString="SUM([Union1062])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1062"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1162"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1063])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1063"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1163"></ColumnReference><ScalarOperator ScalarString="SUM([Union1063])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1063"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1164"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1064])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1064"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1165"></ColumnReference><ScalarOperator ScalarString="SUM([Union1064])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1064"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1166"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1065])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1167"></ColumnReference><ScalarOperator ScalarString="SUM([Union1065])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_site].[web_site_id] = [TPCDS_SF100].[dbo].[web_site].[web_site_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="43" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="550158" EstimateIO="0" EstimateCPU="0.421655" AvgRowSize="47" EstimatedTotalSubtreeCost="79.2789" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1062"></ColumnReference><ColumnReference Column="Union1063"></ColumnReference><ColumnReference Column="Union1064"></ColumnReference><ColumnReference Column="Union1065"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1060"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1060]=[TPCDS_SF100].[dbo].[web_site].[web_site_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1060"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="44" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="24" EstimatedRowsRead="24" EstimateIO="0.003125" EstimateCPU="1.834e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00314334" TableCardinality="24" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_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="[web_site]" Column="web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="45" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="550224" EstimateIO="0" EstimateCPU="0.00643215" AvgRowSize="31" EstimatedTotalSubtreeCost="78.8541" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference><ColumnReference Column="Union1063"></ColumnReference><ColumnReference Column="Union1064"></ColumnReference><ColumnReference Column="Union1065"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1062"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1063"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1064"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1065"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="46" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="593947" EstimateIO="0" EstimateCPU="0.801299" AvgRowSize="31" EstimatedTotalSubtreeCost="41.3246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1134"></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="47" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15.2405" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" 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_date]&gt;=&apos;2000-08-19&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-09-02&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-08-19&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-09-02&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="48" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.19256e+07" EstimateIO="0" EstimateCPU="0.0112384" AvgRowSize="35" EstimatedTotalSubtreeCost="40.4439" 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_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1052"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="49" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.19256e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="32.5208" EstimateCPU="7.91183" AvgRowSize="25" EstimatedTotalSubtreeCost="40.4327" 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_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></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_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="50" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="49268.6" EstimateIO="0" EstimateCPU="0.000492686" AvgRowSize="31" EstimatedTotalSubtreeCost="37.5231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1059"></ColumnReference><ScalarOperator ScalarString="(0.00)"><Const ConstValue="(0.00)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="51" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="49268.6" EstimateIO="0" EstimateCPU="0.185656" AvgRowSize="21" EstimatedTotalSubtreeCost="37.5226" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1138"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_returns].[wr_item_sk]=[TPCDS_SF100].[dbo].[web_sales].[ws_item_sk] AND [TPCDS_SF100].[dbo].[web_returns].[wr_order_number]=[TPCDS_SF100].[dbo].[web_sales].[ws_order_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="52" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="49161" EstimateIO="0" EstimateCPU="0.0301272" AvgRowSize="25" EstimatedTotalSubtreeCost="4.69119" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1139"></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_returns]" Column="wr_returned_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_returns].[wr_returned_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_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="53" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15.2405" EstimatedRowsRead="15.2405" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" 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_date]&gt;=&apos;2000-08-19&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-09-02&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-08-19&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-09-02&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="54" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.87469e+06" EstimatedRowsRead="7.19569e+06" EstimateIO="3.77617" EstimateCPU="0.791542" AvgRowSize="29" EstimatedTotalSubtreeCost="4.56771" TableCardinality="7.19569e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></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_returns]" Column="wr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_returns].[wr_returned_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="55" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.19083e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="24.7164" EstimateCPU="7.91183" AvgRowSize="19" EstimatedTotalSubtreeCost="32.6282" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></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_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></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_web_site_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Concat></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Concat></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
