<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH frequent_ss_items AS (&#xa;  SELECT&#xa;    SUBSTRING(i_item_desc, 1, 30) AS itemdesc,&#xa;    i_item_sk AS item_sk,&#xa;    d_date AS solddate,&#xa;    COUNT(*) AS cnt&#xa;  FROM store_sales, date_dim, item&#xa;  WHERE&#xa;    ss_sold_date_sk = d_date_sk&#xa;    AND ss_item_sk = i_item_sk&#xa;    AND d_year IN (1998, 1998 + 1, 1998 + 2, 1998 + 3)&#xa;  GROUP BY&#xa;    SUBSTRING(i_item_desc, 1, 30),&#xa;    i_item_sk,&#xa;    d_date&#xa;  HAVING&#xa;    COUNT(*) &gt; 4&#xa;), max_store_sales AS (&#xa;  SELECT&#xa;    MAX(csales) AS tpcds_cmax&#xa;  FROM (&#xa;    SELECT&#xa;      c_customer_sk AS c_customer_sk,&#xa;      SUM(ss_quantity * ss_sales_price) AS csales&#xa;    FROM store_sales, customer, date_dim&#xa;    WHERE&#xa;      ss_customer_sk = c_customer_sk&#xa;      AND ss_sold_date_sk = d_date_sk&#xa;      AND d_year IN (1998, 1998 + 1, 1998 + 2, 1998 + 3)&#xa;    GROUP BY&#xa;      c_customer_sk&#xa;  ) AS polaris_derived_1&#xa;), best_ss_customer AS (&#xa;  SELECT&#xa;    c_customer_sk AS c_customer_sk,&#xa;    SUM(ss_quantity * ss_sales_price) AS ssales&#xa;  FROM store_sales, customer&#xa;  WHERE&#xa;    ss_customer_sk = c_customer_sk&#xa;  GROUP BY&#xa;    c_customer_sk&#xa;  HAVING&#xa;    SUM(ss_quantity * ss_sales_price) &gt; (&#xa;      95 / 100.0&#xa;    ) * (&#xa;      SELECT&#xa;        *&#xa;      FROM max_store_sales&#xa;    )&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  SUM(sales)&#xa;FROM (&#xa;  SELECT&#xa;    cs_quantity * cs_list_price AS sales&#xa;  FROM catalog_sales, date_dim&#xa;  WHERE&#xa;    d_year = 1998&#xa;    AND d_moy = 5&#xa;    AND cs_sold_date_sk = d_date_sk&#xa;    AND cs_item_sk IN (&#xa;      SELECT&#xa;        item_sk&#xa;      FROM frequent_ss_items&#xa;    )&#xa;    AND cs_bill_customer_sk IN (&#xa;      SELECT&#xa;        c_customer_sk&#xa;      FROM best_ss_customer&#xa;    )&#xa;  UNION ALL&#xa;  SELECT&#xa;    ws_quantity * ws_list_price AS sales&#xa;  FROM web_sales, date_dim&#xa;  WHERE&#xa;    d_year = 1998&#xa;    AND d_moy = 5&#xa;    AND ws_sold_date_sk = d_date_sk&#xa;    AND ws_item_sk IN (&#xa;      SELECT&#xa;        item_sk&#xa;      FROM frequent_ss_items&#xa;    )&#xa;    AND ws_bill_customer_sk IN (&#xa;      SELECT&#xa;        c_customer_sk&#xa;      FROM best_ss_customer&#xa;    )&#xa;) AS polaris_derived_0" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="7531.38" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x8C342680B75B28E4" QueryPlanHash="0xA1CF6A5CFF98D056" 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="1000" CompileTime="243" CompileCPU="243" CompileMemory="17696"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:32:48.75" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:56.55" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:30.12" ModificationCount="0" SamplingPercent="26.5637" Statistics="[_WA_Sys_00000001_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:17.67" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:29.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:16.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:19.10" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.43" ModificationCount="0" SamplingPercent="73.9837" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:25.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:12.65" ModificationCount="0" SamplingPercent="26.6591" Statistics="[_WA_Sys_00000005_76969D2E]" Table="[item]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:31.05" ModificationCount="0" SamplingPercent="73.9615" Statistics="[_WA_Sys_00000009_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.45" ModificationCount="0" SamplingPercent="73.9544" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:23.20" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:23.73" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:26.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:03.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.19" ModificationCount="0" SamplingPercent="73.9587" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:47.59" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1055"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1055"></ColumnReference><ScalarOperator ScalarString="[Expr1055]"><Identifier><ColumnReference Column="Expr1055"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1055"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1055"></ColumnReference></OutputList><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(100)"><Const ConstValue="(100)"></Const></ScalarOperator></TopExpression><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1055"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1055"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1152]=(0) THEN NULL ELSE [Expr1153] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1152"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1153"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1152"></ColumnReference><ColumnReference Column="Expr1153"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1152"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1070])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1070"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1153"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1070])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1070"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="6" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1070"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.35" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1070"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1070"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1150]=(0) THEN NULL ELSE [Expr1151] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1150"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1151"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00793886" AvgRowSize="24" EstimatedTotalSubtreeCost="7531.35" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1150"></ColumnReference><ColumnReference Column="Expr1151"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1150"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1054])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1151"></ColumnReference><ScalarOperator ScalarString="SUM([Union1054])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="9" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="3.69822e+06" EstimateIO="0" EstimateCPU="0.0061637" AvgRowSize="16" EstimatedTotalSubtreeCost="7531.34" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1054"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1054"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.46182e+06" EstimateIO="0" EstimateCPU="1.25608" AvgRowSize="16" EstimatedTotalSubtreeCost="3865.67" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1071"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1072"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1016]&gt;(0.950000)*[Expr1024] AND [Expr1071]=[Expr1072]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Const ConstValue="(0.950000)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="28" EstimatedTotalSubtreeCost="323.65" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="24" EstimatedTotalSubtreeCost="323.65" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="MAX([partialagg1064])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="partialagg1064"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="13" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="24" EstimatedTotalSubtreeCost="323.648" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1064"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00498014" AvgRowSize="24" EstimatedTotalSubtreeCost="323.615" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1064"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1064"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1023])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="323.61" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1023"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1134]=(0) THEN NULL ELSE [Expr1135] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1134"></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="Expr1135"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="1.0625" AvgRowSize="24" EstimatedTotalSubtreeCost="323.61" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1134"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1134"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1063])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1063"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1135"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1063])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1063"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="17" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.84599e+06" EstimateIO="31.2387" EstimateCPU="1.34609" AvgRowSize="28" EstimatedTotalSubtreeCost="322.548" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1063"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="275.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1063"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1063"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1132]=(0) THEN NULL ELSE [Expr1133] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1132"></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="Expr1133"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="18.1437" AvgRowSize="28" EstimatedTotalSubtreeCost="275.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1132"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1057])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1057"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1057])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1057"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.16396e+08" EstimateIO="0" EstimateCPU="34.4252" AvgRowSize="20" EstimatedTotalSubtreeCost="256.884" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="0.401015" EstimateCPU="0.220443" AvgRowSize="11" EstimatedTotalSubtreeCost="0.621457" TableCardinality="2.00388e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.08108e+08" EstimateIO="0" EstimateCPU="36.0679" AvgRowSize="20" EstimatedTotalSubtreeCost="221.838" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="23" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1454.14" EstimateIO="0.0367034" EstimateCPU="0.0030537" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0873913" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1454.14" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00134533" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0235969" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.63917e+08" EstimateIO="0" EstimateCPU="0.439861" AvgRowSize="24" EstimatedTotalSubtreeCost="185.682" 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_customer_sk"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_sales_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.63917e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="124.905" EstimateCPU="5.27591" AvgRowSize="24" EstimatedTotalSubtreeCost="130.181" 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_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="27" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8.20608e+06" EstimateIO="0" EstimateCPU="0.0136768" AvgRowSize="37" EstimatedTotalSubtreeCost="3540.77" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1072"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="28" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.20608e+06" EstimateIO="0" EstimateCPU="1.86983" AvgRowSize="33" EstimatedTotalSubtreeCost="3540.75" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="29" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="269.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1138]=(0) THEN NULL ELSE [Expr1139] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1138"></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="Expr1139"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="1.0625" AvgRowSize="28" EstimatedTotalSubtreeCost="269.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1138"></ColumnReference><ColumnReference Column="Expr1139"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1138"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1060])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1060"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1139"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1060])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1060"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="31" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.84599e+06" EstimateIO="31.2387" EstimateCPU="1.34609" AvgRowSize="28" EstimatedTotalSubtreeCost="268.137" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="32" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="220.617" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1060"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1136]=(0) THEN NULL ELSE [Expr1137] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1136"></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="Expr1137"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="22.7888" AvgRowSize="28" EstimatedTotalSubtreeCost="220.617" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1136"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1056])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1137"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1056])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.76012e+08" EstimateIO="0" EstimateCPU="43.3705" AvgRowSize="20" EstimatedTotalSubtreeCost="197.828" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="0.401015" EstimateCPU="0.220443" AvgRowSize="11" EstimatedTotalSubtreeCost="0.621457" TableCardinality="2.00388e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.65441e+08" EstimateIO="0" EstimateCPU="0.442401" AvgRowSize="20" EstimatedTotalSubtreeCost="153.836" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_sales_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="37" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65441e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="5.27591" AvgRowSize="20" EstimatedTotalSubtreeCost="109.364" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="38" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="8.20608e+06" EstimateIO="47.6047" EstimateCPU="2.87213" AvgRowSize="20" EstimatedTotalSubtreeCost="3269.68" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="39" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.20608e+06" EstimateIO="0" EstimateCPU="1.45599" AvgRowSize="20" EstimatedTotalSubtreeCost="3196.37" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="40" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="194599" EstimateIO="3.73354" EstimateCPU="0.408658" AvgRowSize="11" EstimatedTotalSubtreeCost="3116.88" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="194599" EstimateIO="0" EstimateCPU="0.130704" AvgRowSize="11" EstimatedTotalSubtreeCost="3112.44" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="42" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.08066e+06" EstimateIO="0" EstimateCPU="6.16412" AvgRowSize="11" EstimatedTotalSubtreeCost="3112.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="43" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.49132e+08" EstimateIO="0" EstimateCPU="0" AvgRowSize="15" EstimatedTotalSubtreeCost="3106.14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1140],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1140"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.49132e+08" EstimateIO="1280.89" EstimateCPU="267.558" AvgRowSize="15" EstimatedTotalSubtreeCost="3106.14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1140"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1140"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1010] = [Expr1010] AND [TPCDS_SF100].[dbo].[item].[i_item_sk] = [TPCDS_SF100].[dbo].[item].[i_item_sk] AND [TPCDS_SF100].[dbo].[date_dim].[d_date] = [TPCDS_SF100].[dbo].[date_dim].[d_date]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="45" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.24126e+08" EstimateIO="0" EstimateCPU="33.9187" AvgRowSize="118" EstimatedTotalSubtreeCost="1557.69" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="46" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="204328" EstimateIO="6.82329" EstimateCPU="0.0715148" AvgRowSize="115" EstimatedTotalSubtreeCost="10.5664" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="47" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="204328" EstimateIO="0" EstimateCPU="0.000340547" AvgRowSize="115" EstimatedTotalSubtreeCost="0.431418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="substring([TPCDS_SF100].[dbo].[item].[i_item_desc],(1),(30))"><Intrinsic FunctionName="substring"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="48" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.427329" EstimateCPU="0.00374863" AvgRowSize="115" EstimatedTotalSubtreeCost="0.431077" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Move></RelOp><RelOp NodeId="49" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="2.16757e+08" EstimateIO="880.055" EstimateCPU="75.8651" AvgRowSize="14" EstimatedTotalSubtreeCost="1513.21" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="50" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.16757e+08" EstimateIO="0" EstimateCPU="37.5672" AvgRowSize="14" EstimatedTotalSubtreeCost="132.904" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></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="51" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1454.14" EstimateIO="0.0442941" EstimateCPU="0.0030537" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0989555" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="52" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1454.14" EstimatedRowsRead="73239" EstimateIO="0.0262251" EstimateCPU="0.00134533" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0275704" 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_date"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="53" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.74886e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="78.0668" EstimateCPU="5.27591" AvgRowSize="15" EstimatedTotalSubtreeCost="83.3427" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1011]&gt;(4)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="54" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.33955e+06" EstimateIO="0" EstimateCPU="1.32203" AvgRowSize="24" EstimatedTotalSubtreeCost="78.032" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1084"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="55" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="108.339" EstimateIO="0.023125" EstimateCPU="0.000227513" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0706473" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="56" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="108.339" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00134533" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0288949" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) AND [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="57" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.42969e+08" EstimateIO="0" EstimateCPU="0.0148926" AvgRowSize="28" EstimatedTotalSubtreeCost="76.6393" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0)*[TPCDS_SF100].[dbo].[catalog_sales].[cs_list_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="58" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42969e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="72.9508" EstimateCPU="2.64115" AvgRowSize="28" EstimatedTotalSubtreeCost="75.5919" TableCardinality="1.44063e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_bill_customer_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="59" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.2364e+06" EstimateIO="0" EstimateCPU="0.631721" AvgRowSize="16" EstimatedTotalSubtreeCost="3665.66" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1071"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1072"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1043]&gt;(0.950000)*[Expr1051] AND [Expr1071]=[Expr1072]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Const ConstValue="(0.950000)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1051"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="60" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="28" EstimatedTotalSubtreeCost="323.65" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="61" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="24" EstimatedTotalSubtreeCost="323.65" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1051"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1051"></ColumnReference><ScalarOperator ScalarString="MAX([partialagg1069])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="partialagg1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="62" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="24" EstimatedTotalSubtreeCost="323.648" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="63" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00498014" AvgRowSize="24" EstimatedTotalSubtreeCost="323.615" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1050])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1050"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="64" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="323.61" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1050"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1050"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1143]=(0) THEN NULL ELSE [Expr1144] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1143"></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="Expr1144"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="65" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="1.0625" AvgRowSize="24" EstimatedTotalSubtreeCost="323.61" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1143"></ColumnReference><ColumnReference Column="Expr1144"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1143"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1068])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1068"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1144"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1068])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1068"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="66" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.84599e+06" EstimateIO="31.2387" EstimateCPU="1.34609" AvgRowSize="28" EstimatedTotalSubtreeCost="322.548" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="67" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="275.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1141]=(0) THEN NULL ELSE [Expr1142] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1141"></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="Expr1142"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="68" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="18.1437" AvgRowSize="28" EstimatedTotalSubtreeCost="275.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1141"></ColumnReference><ColumnReference Column="Expr1142"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1141"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1059])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1142"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1059])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="69" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.16396e+08" EstimateIO="0" EstimateCPU="34.4252" AvgRowSize="20" EstimatedTotalSubtreeCost="256.884" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="70" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="0.401015" EstimateCPU="0.220443" AvgRowSize="11" EstimatedTotalSubtreeCost="0.621457" TableCardinality="2.00388e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="71" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.08108e+08" EstimateIO="0" EstimateCPU="36.0679" AvgRowSize="20" EstimatedTotalSubtreeCost="221.838" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="72" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1454.14" EstimateIO="0.0367034" EstimateCPU="0.0030537" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0873913" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="73" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1454.14" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00134533" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0235969" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="74" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.63917e+08" EstimateIO="0" EstimateCPU="0.439861" AvgRowSize="24" EstimatedTotalSubtreeCost="185.682" 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_customer_sk"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1059"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_sales_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="75" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.63917e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="124.905" EstimateCPU="5.27591" AvgRowSize="24" EstimatedTotalSubtreeCost="130.181" 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_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="76" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.12132e+06" EstimateIO="0" EstimateCPU="0.00686887" AvgRowSize="37" EstimatedTotalSubtreeCost="3341.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1072"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="77" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.12132e+06" EstimateIO="0" EstimateCPU="0.829274" AvgRowSize="33" EstimatedTotalSubtreeCost="3341.37" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="78" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="194599" EstimateIO="3.73354" EstimateCPU="0.408658" AvgRowSize="11" EstimatedTotalSubtreeCost="3116.88" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="79" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="194599" EstimateIO="0" EstimateCPU="0.130704" AvgRowSize="11" EstimatedTotalSubtreeCost="3112.44" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="80" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.08066e+06" EstimateIO="0" EstimateCPU="6.16412" AvgRowSize="11" EstimatedTotalSubtreeCost="3112.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="81" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.49132e+08" EstimateIO="0" EstimateCPU="0" AvgRowSize="15" EstimatedTotalSubtreeCost="3106.14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1038"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1038"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1145],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1145"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="82" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.49132e+08" EstimateIO="1280.89" EstimateCPU="267.558" AvgRowSize="15" EstimatedTotalSubtreeCost="3106.14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1145"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1145"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1037] = [Expr1037] AND [TPCDS_SF100].[dbo].[item].[i_item_sk] = [TPCDS_SF100].[dbo].[item].[i_item_sk] AND [TPCDS_SF100].[dbo].[date_dim].[d_date] = [TPCDS_SF100].[dbo].[date_dim].[d_date]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="83" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.24126e+08" EstimateIO="0" EstimateCPU="33.9187" AvgRowSize="118" EstimatedTotalSubtreeCost="1557.69" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="84" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="204328" EstimateIO="6.82329" EstimateCPU="0.0715148" AvgRowSize="115" EstimatedTotalSubtreeCost="10.5664" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="85" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="204328" EstimateIO="0" EstimateCPU="0.000340547" AvgRowSize="115" EstimatedTotalSubtreeCost="0.431418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1037"></ColumnReference><ScalarOperator ScalarString="substring([TPCDS_SF100].[dbo].[item].[i_item_desc],(1),(30))"><Intrinsic FunctionName="substring"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="86" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="204328" EstimatedRowsRead="204328" EstimateIO="0.427329" EstimateCPU="0.00374863" AvgRowSize="115" EstimatedTotalSubtreeCost="0.431077" TableCardinality="204328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_desc"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Move></RelOp><RelOp NodeId="87" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="2.16757e+08" EstimateIO="880.055" EstimateCPU="75.8651" AvgRowSize="14" EstimatedTotalSubtreeCost="1513.21" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DistributionKey><RelOp NodeId="88" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.16757e+08" EstimateIO="0" EstimateCPU="37.5672" AvgRowSize="14" EstimatedTotalSubtreeCost="132.904" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></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="89" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1454.14" EstimateIO="0.0442941" EstimateCPU="0.0030537" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0989555" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="90" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1454.14" EstimatedRowsRead="73239" EstimateIO="0.0262251" EstimateCPU="0.00134533" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0275704" 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_date"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000) OR [TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="91" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.74886e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="78.0668" EstimateCPU="5.27591" AvgRowSize="15" EstimatedTotalSubtreeCost="83.3427" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1038]&gt;(4)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1038"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="92" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.2239e+06" EstimateIO="0" EstimateCPU="0.668067" AvgRowSize="37" EstimatedTotalSubtreeCost="223.664" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1118"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="93" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="108.339" EstimateIO="0.396918" EstimateCPU="0.000248513" AvgRowSize="11" EstimatedTotalSubtreeCost="0.612029" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="94" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="108.339" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00134533" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0288949" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1998) AND [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1998)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="95" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.23847e+06" EstimateIO="0" EstimateCPU="1.80213" AvgRowSize="41" EstimatedTotalSubtreeCost="222.384" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1115"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="96" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="4.23854e+06" EstimateIO="41.1479" EstimateCPU="1.5728" AvgRowSize="28" EstimatedTotalSubtreeCost="100.629" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="97" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.23854e+06" EstimateIO="0" EstimateCPU="0.00748943" AvgRowSize="28" EstimatedTotalSubtreeCost="38.2646" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0)*[TPCDS_SF100].[dbo].[web_sales].[ws_list_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="99" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.23854e+06" EstimatedRowsRead="7.19256e+07" EstimateIO="36.423" EstimateCPU="1.31864" AvgRowSize="28" EstimatedTotalSubtreeCost="37.7417" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_bill_customer_sk] IS NOT NULL AND PROBE([Opt_Bitmap1118],[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk])"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1118"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Move></RelOp><RelOp NodeId="100" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="119.953" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1148]=(0) THEN NULL ELSE [Expr1149] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1148"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1149"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="101" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.92299e+06" EstimateIO="0" EstimateCPU="0.0680702" AvgRowSize="28" EstimatedTotalSubtreeCost="119.953" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1148"></ColumnReference><ColumnReference Column="Expr1149"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1148"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1065])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1149"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1065])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="102" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.84599e+06" EstimateIO="1.96073" EstimateCPU="0.0841309" AvgRowSize="28" EstimatedTotalSubtreeCost="119.885" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1065"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></DistributionKey><RelOp NodeId="103" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="116.903" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="partialagg1065"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1065"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1146]=(0) THEN NULL ELSE [Expr1147] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1146"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1147"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="104" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.84599e+06" EstimateIO="0" EstimateCPU="1.42597" AvgRowSize="28" EstimatedTotalSubtreeCost="116.903" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1146"></ColumnReference><ColumnReference Column="Expr1147"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1146"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1058])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1058"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1147"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1058])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1058"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="105" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.76012e+08" EstimateIO="0" EstimateCPU="2.71221" AvgRowSize="20" EstimatedTotalSubtreeCost="115.477" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1107"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="106" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="0.401015" EstimateCPU="0.220443" AvgRowSize="11" EstimatedTotalSubtreeCost="0.621457" TableCardinality="2.00388e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="107" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.65441e+08" EstimateIO="0" EstimateCPU="0.0276501" AvgRowSize="20" EstimatedTotalSubtreeCost="112.144" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[store_sales].[ss_quantity],0)*[TPCDS_SF100].[dbo].[store_sales].[ss_sales_price]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="108" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65441e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="104.088" EstimateCPU="5.27591" AvgRowSize="20" EstimatedTotalSubtreeCost="109.364" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_sales_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Concat></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Top></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
