<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH wss AS (&#xa;  SELECT&#xa;    d_week_seq AS d_week_seq,&#xa;    ss_store_sk AS ss_store_sk,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Sunday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS sun_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Monday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS mon_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Tuesday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS tue_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Wednesday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS wed_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Thursday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS thu_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Friday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS fri_sales,&#xa;    SUM(CASE WHEN (&#xa;      d_day_name = &apos;Saturday&apos;&#xa;    ) THEN ss_sales_price ELSE NULL END) AS sat_sales&#xa;  FROM store_sales, date_dim&#xa;  WHERE&#xa;    d_date_sk = ss_sold_date_sk&#xa;  GROUP BY&#xa;    d_week_seq,&#xa;    ss_store_sk&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  s_store_name1,&#xa;  s_store_id1,&#xa;  d_week_seq1,&#xa;  sun_sales1 / sun_sales2,&#xa;  mon_sales1 / mon_sales2,&#xa;  tue_sales1 / tue_sales2,&#xa;  wed_sales1 / wed_sales2,&#xa;  thu_sales1 / thu_sales2,&#xa;  fri_sales1 / fri_sales2,&#xa;  sat_sales1 / sat_sales2&#xa;FROM (&#xa;  SELECT&#xa;    s_store_name AS s_store_name1,&#xa;    wss.d_week_seq AS d_week_seq1,&#xa;    s_store_id AS s_store_id1,&#xa;    sun_sales AS sun_sales1,&#xa;    mon_sales AS mon_sales1,&#xa;    tue_sales AS tue_sales1,&#xa;    wed_sales AS wed_sales1,&#xa;    thu_sales AS thu_sales1,&#xa;    fri_sales AS fri_sales1,&#xa;    sat_sales AS sat_sales1&#xa;  FROM wss, store, date_dim AS d&#xa;  WHERE&#xa;    d.d_week_seq = wss.d_week_seq&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND d_month_seq BETWEEN 1197 AND 1197 + 11&#xa;) AS y, (&#xa;  SELECT&#xa;    s_store_name AS s_store_name2,&#xa;    wss.d_week_seq AS d_week_seq2,&#xa;    s_store_id AS s_store_id2,&#xa;    sun_sales AS sun_sales2,&#xa;    mon_sales AS mon_sales2,&#xa;    tue_sales AS tue_sales2,&#xa;    wed_sales AS wed_sales2,&#xa;    thu_sales AS thu_sales2,&#xa;    fri_sales AS fri_sales2,&#xa;    sat_sales AS sat_sales2&#xa;  FROM wss, store, date_dim AS d&#xa;  WHERE&#xa;    d.d_week_seq = wss.d_week_seq&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND d_month_seq BETWEEN 1197 + 12 AND 1197 + 23&#xa;) AS x&#xa;WHERE&#xa;  s_store_id1 = s_store_id2 AND d_week_seq1 = d_week_seq2 - 52&#xa;ORDER BY&#xa;  s_store_name1,&#xa;  s_store_id1,&#xa;  d_week_seq1" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="270.873" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3A7C870FC1262B9B" QueryPlanHash="0xD086404F9A081A82" 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="864" CompileTime="170" CompileCPU="170" CompileMemory="16512"><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: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: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: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:32:34" ModificationCount="0" SamplingPercent="73.9366" Statistics="[_WA_Sys_00000004_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:24.55" ModificationCount="0" SamplingPercent="74.005" Statistics="[_WA_Sys_00000005_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15: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></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="178" EstimatedTotalSubtreeCost="270.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[Expr1028]"><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="[Expr1029]"><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="[Expr1030]"><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="[Expr1031]"><Identifier><ColumnReference Column="Expr1031"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="[Expr1032]"><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="[Expr1033]"><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="[Expr1034]"><Identifier><ColumnReference Column="Expr1034"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="178" EstimatedTotalSubtreeCost="270.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="178" EstimatedTotalSubtreeCost="270.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[Expr1004]/[Expr1018]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="[Expr1005]/[Expr1019]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="[Expr1006]/[Expr1020]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="[Expr1007]/[Expr1021]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="[Expr1008]/[Expr1022]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1022"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="[Expr1009]/[Expr1023]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="[Expr1010]/[Expr1024]"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000305913" AvgRowSize="298" EstimatedTotalSubtreeCost="270.873" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0.0607234" EstimateCPU="0.00021" AvgRowSize="298" EstimatedTotalSubtreeCost="270.867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="6" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000349132" AvgRowSize="298" EstimatedTotalSubtreeCost="270.79" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="122.422" EstimateIO="0" EstimateCPU="0.0108058" AvgRowSize="298" EstimatedTotalSubtreeCost="270.784" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1177"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_id]=[TPCDS_SF100].[dbo].[store].[s_store_id] AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><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><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="23" 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" IsImplicitBroadcast="1"><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]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="12303.4" EstimateIO="0" EstimateCPU="0.00964509" AvgRowSize="302" EstimatedTotalSubtreeCost="270.77" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></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 Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="58" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="12303.4" EstimateIO="0" EstimateCPU="0.0132743" AvgRowSize="259" EstimatedTotalSubtreeCost="270.757" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1179"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1035"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] as [d].[d_week_seq]=[Expr1035]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="359.526" EstimateIO="0.023125" EstimateCPU="0.000377503" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0934428" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></DistributionKey><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="359.526" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.004036" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0262876" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_month_seq] as [d].[d_month_seq]&gt;=(1197) AND [TPCDS_SF100].[dbo].[date_dim].[d_month_seq] as [d].[d_month_seq]&lt;=(1208) AND [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] as [d].[d_week_seq] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1197)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1208)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="356943" EstimateIO="0" EstimateCPU="0.0181626" AvgRowSize="263" EstimatedTotalSubtreeCost="270.65" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1180"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1035"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq]=[Expr1035]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="15" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="11080" EstimateIO="1.68403" EstimateCPU="0.011655" AvgRowSize="135" EstimatedTotalSubtreeCost="147.606" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Column="Expr1035"></ColumnReference></DistributionKey><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="11080" EstimateIO="0" EstimateCPU="0.00761651" AvgRowSize="135" EstimatedTotalSubtreeCost="145.122" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1182"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></HashKeysProbe><RelOp NodeId="17" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="342.403" EstimateIO="0.396918" EstimateCPU="0.000380523" AvgRowSize="11" EstimatedTotalSubtreeCost="0.634805" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></DistributionKey><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="342.403" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.004036" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0262876" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" Alias="[d]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_month_seq] as [d].[d_month_seq]&gt;=(1209) AND [TPCDS_SF100].[dbo].[date_dim].[d_month_seq] as [d].[d_month_seq]&lt;=(1220) AND [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] as [d].[d_week_seq] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1209)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1220)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Alias="[d]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10966.3" EstimateIO="0" EstimateCPU="0.000105483" AvgRowSize="139" EstimatedTotalSubtreeCost="144.479" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq]-(52)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(52)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="20" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10966.3" EstimateIO="0" EstimateCPU="0" AvgRowSize="135" EstimatedTotalSubtreeCost="144.479" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1932]=(0) THEN NULL ELSE [Expr1933] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1932"></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="Expr1933"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1934]=(0) THEN NULL ELSE [Expr1935] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1934"></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="Expr1935"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1936]=(0) THEN NULL ELSE [Expr1937] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1936"></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="Expr1937"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1938]=(0) THEN NULL ELSE [Expr1939] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1938"></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="Expr1939"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1940]=(0) THEN NULL ELSE [Expr1941] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1940"></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="Expr1941"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1942]=(0) THEN NULL ELSE [Expr1943] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1942"></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="Expr1943"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1944]=(0) THEN NULL ELSE [Expr1945] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1944"></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="Expr1945"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="10966.3" EstimateIO="0" EstimateCPU="0.123114" AvgRowSize="135" EstimatedTotalSubtreeCost="144.479" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1932"></ColumnReference><ColumnReference Column="Expr1933"></ColumnReference><ColumnReference Column="Expr1934"></ColumnReference><ColumnReference Column="Expr1935"></ColumnReference><ColumnReference Column="Expr1936"></ColumnReference><ColumnReference Column="Expr1937"></ColumnReference><ColumnReference Column="Expr1938"></ColumnReference><ColumnReference Column="Expr1939"></ColumnReference><ColumnReference Column="Expr1940"></ColumnReference><ColumnReference Column="Expr1941"></ColumnReference><ColumnReference Column="Expr1942"></ColumnReference><ColumnReference Column="Expr1943"></ColumnReference><ColumnReference Column="Expr1944"></ColumnReference><ColumnReference Column="Expr1945"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1932"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1036])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1933"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1934"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1037])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1037"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1935"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1037])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1037"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1936"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1038])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1937"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1038])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1938"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1039])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1039"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1939"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1039])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1039"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1940"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1040])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1941"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1040])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1942"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1041])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1041"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1943"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1041])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1041"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1944"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1042])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1042"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1945"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1042])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1042"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] = [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] = [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="22" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="21932.5" EstimateIO="4.96453" EstimateCPU="0.0443029" AvgRowSize="135" EstimatedTotalSubtreeCost="144.356" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1037"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1039"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference><ColumnReference Column="partialagg1041"></ColumnReference><ColumnReference Column="partialagg1042"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></DistributionKey><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="21932.5" EstimateIO="0" EstimateCPU="0" AvgRowSize="135" EstimatedTotalSubtreeCost="136.991" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1037"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1039"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference><ColumnReference Column="partialagg1041"></ColumnReference><ColumnReference Column="partialagg1042"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1036"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1918]=(0) THEN NULL ELSE [Expr1919] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1918"></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="Expr1919"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1037"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1920]=(0) THEN NULL ELSE [Expr1921] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1920"></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="Expr1921"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1038"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1922]=(0) THEN NULL ELSE [Expr1923] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1922"></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="Expr1923"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1039"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1924]=(0) THEN NULL ELSE [Expr1925] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1924"></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="Expr1925"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1040"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1926]=(0) THEN NULL ELSE [Expr1927] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1926"></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="Expr1927"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1041"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1928]=(0) THEN NULL ELSE [Expr1929] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1928"></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="Expr1929"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1042"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1930]=(0) THEN NULL ELSE [Expr1931] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1930"></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="Expr1931"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="21932.5" EstimateIO="0" EstimateCPU="5.64063" AvgRowSize="135" EstimatedTotalSubtreeCost="136.991" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1918"></ColumnReference><ColumnReference Column="Expr1919"></ColumnReference><ColumnReference Column="Expr1920"></ColumnReference><ColumnReference Column="Expr1921"></ColumnReference><ColumnReference Column="Expr1922"></ColumnReference><ColumnReference Column="Expr1923"></ColumnReference><ColumnReference Column="Expr1924"></ColumnReference><ColumnReference Column="Expr1925"></ColumnReference><ColumnReference Column="Expr1926"></ColumnReference><ColumnReference Column="Expr1927"></ColumnReference><ColumnReference Column="Expr1928"></ColumnReference><ColumnReference Column="Expr1929"></ColumnReference><ColumnReference Column="Expr1930"></ColumnReference><ColumnReference Column="Expr1931"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1918"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1228])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1228"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1919"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1228])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1228"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1920"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1229])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1229"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1921"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1229])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1229"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1922"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1230])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1230"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1923"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1230])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1230"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1924"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1231])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1231"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1925"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1231])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1231"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1926"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1232])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1232"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1927"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1232])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1232"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1928"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1233])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1233"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1929"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1233])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1233"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1930"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1234])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1234"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1931"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1234])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1234"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] = [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] = [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8.62905e+06" EstimateIO="0" EstimateCPU="0.0830018" AvgRowSize="51" EstimatedTotalSubtreeCost="131.35" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1228"></ColumnReference><ColumnReference Column="Expr1229"></ColumnReference><ColumnReference Column="Expr1230"></ColumnReference><ColumnReference Column="Expr1231"></ColumnReference><ColumnReference Column="Expr1232"></ColumnReference><ColumnReference Column="Expr1233"></ColumnReference><ColumnReference Column="Expr1234"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1228"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Sunday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Sunday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1229"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Monday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Monday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1230"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Tuesday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Tuesday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1231"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Wednesday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Wednesday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1232"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Thursday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Thursday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1233"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Friday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Friday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1234"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Saturday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Saturday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.62905e+06" EstimateIO="0" EstimateCPU="5.12171" AvgRowSize="28" EstimatedTotalSubtreeCost="131.267" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><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_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1227"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2379.4" EstimatedRowsRead="73239" EstimateIO="0.0328475" EstimateCPU="0.00807199" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0409195" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></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_week_seq] IS NOT NULL AND PROBE([Opt_Bitmap1182],[TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1182"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.68681e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="15.8277" AvgRowSize="20" EstimatedTotalSubtreeCost="119.916" 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_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="30" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1766.39" EstimateIO="0" EstimateCPU="0" AvgRowSize="135" EstimatedTotalSubtreeCost="123.026" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1960]=(0) THEN NULL ELSE [Expr1961] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1960"></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="Expr1961"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1962]=(0) THEN NULL ELSE [Expr1963] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1962"></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="Expr1963"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1964]=(0) THEN NULL ELSE [Expr1965] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1964"></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="Expr1965"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1966]=(0) THEN NULL ELSE [Expr1967] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1966"></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="Expr1967"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1968]=(0) THEN NULL ELSE [Expr1969] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1968"></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="Expr1969"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1970]=(0) THEN NULL ELSE [Expr1971] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1970"></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="Expr1971"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1972]=(0) THEN NULL ELSE [Expr1973] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1972"></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="Expr1973"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1766.39" EstimateIO="0" EstimateCPU="0.00556684" AvgRowSize="135" EstimatedTotalSubtreeCost="123.026" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1960"></ColumnReference><ColumnReference Column="Expr1961"></ColumnReference><ColumnReference Column="Expr1962"></ColumnReference><ColumnReference Column="Expr1963"></ColumnReference><ColumnReference Column="Expr1964"></ColumnReference><ColumnReference Column="Expr1965"></ColumnReference><ColumnReference Column="Expr1966"></ColumnReference><ColumnReference Column="Expr1967"></ColumnReference><ColumnReference Column="Expr1968"></ColumnReference><ColumnReference Column="Expr1969"></ColumnReference><ColumnReference Column="Expr1970"></ColumnReference><ColumnReference Column="Expr1971"></ColumnReference><ColumnReference Column="Expr1972"></ColumnReference><ColumnReference Column="Expr1973"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1960"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1043])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1043"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1961"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1043])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1043"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1962"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1044])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1044"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1963"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1044])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1044"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1964"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1045])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1045"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1965"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1045])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1045"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1966"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1046])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1046"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1967"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1046])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1046"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1968"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1047])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1047"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1969"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1047])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1047"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1970"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1048])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1048"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1971"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1048])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1048"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1972"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1049])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1049"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1973"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1049])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1049"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] = [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] = [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="32" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3532.79" EstimateIO="0.628328" EstimateCPU="0.00553787" AvgRowSize="135" EstimatedTotalSubtreeCost="123.021" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="partialagg1043"></ColumnReference><ColumnReference Column="partialagg1044"></ColumnReference><ColumnReference Column="partialagg1045"></ColumnReference><ColumnReference Column="partialagg1046"></ColumnReference><ColumnReference Column="partialagg1047"></ColumnReference><ColumnReference Column="partialagg1048"></ColumnReference><ColumnReference Column="partialagg1049"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></DistributionKey><RelOp NodeId="33" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3532.79" EstimateIO="0" EstimateCPU="0" AvgRowSize="135" EstimatedTotalSubtreeCost="122.089" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="partialagg1043"></ColumnReference><ColumnReference Column="partialagg1044"></ColumnReference><ColumnReference Column="partialagg1045"></ColumnReference><ColumnReference Column="partialagg1046"></ColumnReference><ColumnReference Column="partialagg1047"></ColumnReference><ColumnReference Column="partialagg1048"></ColumnReference><ColumnReference Column="partialagg1049"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1043"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1946]=(0) THEN NULL ELSE [Expr1947] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1946"></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="Expr1947"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1044"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1948]=(0) THEN NULL ELSE [Expr1949] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1948"></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="Expr1949"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1045"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1950]=(0) THEN NULL ELSE [Expr1951] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1950"></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="Expr1951"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1046"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1952]=(0) THEN NULL ELSE [Expr1953] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1952"></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="Expr1953"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1047"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1954]=(0) THEN NULL ELSE [Expr1955] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1954"></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="Expr1955"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1048"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1956]=(0) THEN NULL ELSE [Expr1957] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1956"></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="Expr1957"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1049"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1958]=(0) THEN NULL ELSE [Expr1959] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1958"></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="Expr1959"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3532.79" EstimateIO="0" EstimateCPU="0.706631" AvgRowSize="135" EstimatedTotalSubtreeCost="122.089" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1946"></ColumnReference><ColumnReference Column="Expr1947"></ColumnReference><ColumnReference Column="Expr1948"></ColumnReference><ColumnReference Column="Expr1949"></ColumnReference><ColumnReference Column="Expr1950"></ColumnReference><ColumnReference Column="Expr1951"></ColumnReference><ColumnReference Column="Expr1952"></ColumnReference><ColumnReference Column="Expr1953"></ColumnReference><ColumnReference Column="Expr1954"></ColumnReference><ColumnReference Column="Expr1955"></ColumnReference><ColumnReference Column="Expr1956"></ColumnReference><ColumnReference Column="Expr1957"></ColumnReference><ColumnReference Column="Expr1958"></ColumnReference><ColumnReference Column="Expr1959"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1946"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1332])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1332"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1947"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1332])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1332"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1948"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1333])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1333"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1949"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1333])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1333"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1950"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1334])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1334"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1951"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1334])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1334"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1952"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1335])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1335"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1953"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1335])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1335"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1954"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1336])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1336"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1955"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1336])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1336"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1956"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1337])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1337"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1957"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1337])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1337"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1958"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1338])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1338"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1959"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1338])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1338"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] = [TPCDS_SF100].[dbo].[date_dim].[d_week_seq] AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] = [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="35" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.38993e+06" EstimateIO="0" EstimateCPU="0.0103752" AvgRowSize="51" EstimatedTotalSubtreeCost="121.383" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Column="Expr1332"></ColumnReference><ColumnReference Column="Expr1333"></ColumnReference><ColumnReference Column="Expr1334"></ColumnReference><ColumnReference Column="Expr1335"></ColumnReference><ColumnReference Column="Expr1336"></ColumnReference><ColumnReference Column="Expr1337"></ColumnReference><ColumnReference Column="Expr1338"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1332"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Sunday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Sunday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1333"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Monday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Monday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1334"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Tuesday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Tuesday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1335"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Wednesday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Wednesday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1336"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Thursday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Thursday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1337"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Friday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Friday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1338"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_day_name]=&apos;Saturday&apos; THEN [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Saturday&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="36" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.38993e+06" EstimateIO="0" EstimateCPU="0.641766" AvgRowSize="28" EstimatedTotalSubtreeCost="121.372" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><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_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1331"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="38" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="383.263" EstimatedRowsRead="73239" EstimateIO="0.0328475" EstimateCPU="0.00807199" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0409195" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_day_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_week_seq] IS NOT NULL AND PROBE([Opt_Bitmap1180],[TPCDS_SF100].[dbo].[date_dim].[d_week_seq])"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1180"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_week_seq"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.68681e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="15.8277" AvgRowSize="20" EstimatedTotalSubtreeCost="119.916" 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_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></TopSort></RelOp></ComputeScalar></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
