<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH year_total AS (&#xa;  SELECT&#xa;    c_customer_id AS customer_id,&#xa;    c_first_name AS customer_first_name,&#xa;    c_last_name AS customer_last_name,&#xa;    c_preferred_cust_flag AS customer_preferred_cust_flag,&#xa;    c_birth_country AS customer_birth_country,&#xa;    c_login AS customer_login,&#xa;    c_email_address AS customer_email_address,&#xa;    d_year AS dyear,&#xa;    SUM(&#xa;      (&#xa;        (&#xa;          ss_ext_list_price - ss_ext_wholesale_cost - ss_ext_discount_amt&#xa;        ) + ss_ext_sales_price&#xa;      ) / 2&#xa;    ) AS year_total,&#xa;    &apos;s&apos; AS sale_type&#xa;  FROM customer, store_sales, date_dim&#xa;  WHERE&#xa;    c_customer_sk = ss_customer_sk AND ss_sold_date_sk = d_date_sk&#xa;  GROUP BY&#xa;    c_customer_id,&#xa;    c_first_name,&#xa;    c_last_name,&#xa;    c_preferred_cust_flag,&#xa;    c_birth_country,&#xa;    c_login,&#xa;    c_email_address,&#xa;    d_year&#xa;  UNION ALL&#xa;  SELECT&#xa;    c_customer_id AS customer_id,&#xa;    c_first_name AS customer_first_name,&#xa;    c_last_name AS customer_last_name,&#xa;    c_preferred_cust_flag AS customer_preferred_cust_flag,&#xa;    c_birth_country AS customer_birth_country,&#xa;    c_login AS customer_login,&#xa;    c_email_address AS customer_email_address,&#xa;    d_year AS dyear,&#xa;    SUM(&#xa;      (&#xa;        (&#xa;          (&#xa;            cs_ext_list_price - cs_ext_wholesale_cost - cs_ext_discount_amt&#xa;          ) + cs_ext_sales_price&#xa;        ) / 2&#xa;      )&#xa;    ) AS year_total,&#xa;    &apos;c&apos; AS sale_type&#xa;  FROM customer, catalog_sales, date_dim&#xa;  WHERE&#xa;    c_customer_sk = cs_bill_customer_sk AND cs_sold_date_sk = d_date_sk&#xa;  GROUP BY&#xa;    c_customer_id,&#xa;    c_first_name,&#xa;    c_last_name,&#xa;    c_preferred_cust_flag,&#xa;    c_birth_country,&#xa;    c_login,&#xa;    c_email_address,&#xa;    d_year&#xa;  UNION ALL&#xa;  SELECT&#xa;    c_customer_id AS customer_id,&#xa;    c_first_name AS customer_first_name,&#xa;    c_last_name AS customer_last_name,&#xa;    c_preferred_cust_flag AS customer_preferred_cust_flag,&#xa;    c_birth_country AS customer_birth_country,&#xa;    c_login AS customer_login,&#xa;    c_email_address AS customer_email_address,&#xa;    d_year AS dyear,&#xa;    SUM(&#xa;      (&#xa;        (&#xa;          (&#xa;            ws_ext_list_price - ws_ext_wholesale_cost - ws_ext_discount_amt&#xa;          ) + ws_ext_sales_price&#xa;        ) / 2&#xa;      )&#xa;    ) AS year_total,&#xa;    &apos;w&apos; AS sale_type&#xa;  FROM customer, web_sales, date_dim&#xa;  WHERE&#xa;    c_customer_sk = ws_bill_customer_sk AND ws_sold_date_sk = d_date_sk&#xa;  GROUP BY&#xa;    c_customer_id,&#xa;    c_first_name,&#xa;    c_last_name,&#xa;    c_preferred_cust_flag,&#xa;    c_birth_country,&#xa;    c_login,&#xa;    c_email_address,&#xa;    d_year&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  t_s_secyear.customer_id,&#xa;  t_s_secyear.customer_first_name,&#xa;  t_s_secyear.customer_last_name,&#xa;  t_s_secyear.customer_birth_country&#xa;FROM year_total AS t_s_firstyear, year_total AS t_s_secyear, year_total AS t_c_firstyear, year_total AS t_c_secyear, year_total AS t_w_firstyear, year_total AS t_w_secyear&#xa;WHERE&#xa;  t_s_secyear.customer_id = t_s_firstyear.customer_id&#xa;  AND t_s_firstyear.customer_id = t_c_secyear.customer_id&#xa;  AND t_s_firstyear.customer_id = t_c_firstyear.customer_id&#xa;  AND t_s_firstyear.customer_id = t_w_firstyear.customer_id&#xa;  AND t_s_firstyear.customer_id = t_w_secyear.customer_id&#xa;  AND t_s_firstyear.sale_type = &apos;s&apos;&#xa;  AND t_c_firstyear.sale_type = &apos;c&apos;&#xa;  AND t_w_firstyear.sale_type = &apos;w&apos;&#xa;  AND t_s_secyear.sale_type = &apos;s&apos;&#xa;  AND t_c_secyear.sale_type = &apos;c&apos;&#xa;  AND t_w_secyear.sale_type = &apos;w&apos;&#xa;  AND t_s_firstyear.dyear = 1999&#xa;  AND t_s_secyear.dyear = 1999 + 1&#xa;  AND t_c_firstyear.dyear = 1999&#xa;  AND t_c_secyear.dyear = 1999 + 1&#xa;  AND t_w_firstyear.dyear = 1999&#xa;  AND t_w_secyear.dyear = 1999 + 1&#xa;  AND t_s_firstyear.year_total &gt; 0&#xa;  AND t_c_firstyear.year_total &gt; 0&#xa;  AND t_w_firstyear.year_total &gt; 0&#xa;  AND CASE&#xa;    WHEN t_c_firstyear.year_total &gt; 0&#xa;    THEN t_c_secyear.year_total / t_c_firstyear.year_total&#xa;    ELSE NULL&#xa;  END &gt; CASE&#xa;    WHEN t_s_firstyear.year_total &gt; 0&#xa;    THEN t_s_secyear.year_total / t_s_firstyear.year_total&#xa;    ELSE NULL&#xa;  END&#xa;  AND CASE&#xa;    WHEN t_c_firstyear.year_total &gt; 0&#xa;    THEN t_c_secyear.year_total / t_c_firstyear.year_total&#xa;    ELSE NULL&#xa;  END &gt; CASE&#xa;    WHEN t" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="1884.82" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE9FA2B5F57E162AA" QueryPlanHash="0x149FCF86525B3009" 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="1488" CompileTime="492" CompileCPU="492" CompileMemory="45560"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:31:58.29" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000017_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:43.45" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:55.78" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000019_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:26.48" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:35.74" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000001A_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:45.41" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000F_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:42:26.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000A_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:28.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:27.04" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000F_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:38.55" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:51.70" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000019_04E4BC85]" Table="[catalog_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:31:59.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000018_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:25.69" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_08B54D69]" Table="[customer]" 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:31:50.33" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000018_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:40.96" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_05D8E0BE]" Table="[store_sales]" 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:42:25.22" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_08B54D69]" Table="[customer]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:48.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000017_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:57.41" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000001A_03F0984C]" Table="[web_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:42:27.22" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_08B54D69]" Table="[customer]" 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="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="8e-07" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.82" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1058"></ColumnReference><ScalarOperator ScalarString="[Union1058]"><Identifier><ColumnReference Column="Union1058"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1059"></ColumnReference><ScalarOperator ScalarString="[Union1059]"><Identifier><ColumnReference Column="Union1059"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1060"></ColumnReference><ScalarOperator ScalarString="[Union1060]"><Identifier><ColumnReference Column="Union1060"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1062"></ColumnReference><ScalarOperator ScalarString="[Union1062]"><Identifier><ColumnReference Column="Union1062"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="8e-07" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.82" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000305645" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.82" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0.029577" EstimateCPU="0.00021" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.81" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="6" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00281532" EstimateCPU="0.251434" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.77" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="47041.7" EstimateIO="0" EstimateCPU="0.167217" AvgRowSize="119" EstimatedTotalSubtreeCost="1884.52" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1296"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]=[TPCDS_SF100].[dbo].[customer].[c_customer_id] AND CASE WHEN [Expr1082]&gt;(0.000000) THEN [Expr1116]/[Expr1082] ELSE NULL END&gt;CASE WHEN [Expr1006]&gt;(0.000000) THEN [Expr1040]/[Expr1006] ELSE NULL END"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1040"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="47042.3" EstimateIO="0" EstimateCPU="0.211579" AvgRowSize="88" EstimatedTotalSubtreeCost="1669.52" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1668"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]=[TPCDS_SF100].[dbo].[customer].[c_customer_id] AND CASE WHEN [Expr1082]&gt;(0.000000) THEN [Expr1116]/[Expr1082] ELSE NULL END&gt;CASE WHEN [Expr1158]&gt;(0.000000) THEN [Expr1192]/[Expr1158] ELSE NULL END"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1158"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1192"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1158"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="47108.4" EstimateIO="0" EstimateCPU="0.19475" AvgRowSize="105" EstimatedTotalSubtreeCost="1532.39" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1192"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1629"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]=[TPCDS_SF100].[dbo].[customer].[c_customer_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="49939.8" EstimateIO="0" EstimateCPU="0.393134" AvgRowSize="88" EstimatedTotalSubtreeCost="1447.37" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1591"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]=[TPCDS_SF100].[dbo].[customer].[c_customer_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="166468" EstimateIO="0" EstimateCPU="1.02543" AvgRowSize="53" EstimatedTotalSubtreeCost="1139" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1082"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1555"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]=[TPCDS_SF100].[dbo].[customer].[c_customer_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="555674" EstimateIO="0" EstimateCPU="0.229678" AvgRowSize="36" EstimatedTotalSubtreeCost="664.069" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.85225e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="36" EstimatedTotalSubtreeCost="663.84" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1158"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1158"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1798]=(0) THEN NULL ELSE [Expr1799] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1798"></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="Expr1799"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.85225e+06" EstimateIO="0" EstimateCPU="10.4706" AvgRowSize="36" EstimatedTotalSubtreeCost="663.84" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1798"></ColumnReference><ColumnReference Column="Expr1799"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1798"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1212])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1212"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1799"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1212])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1212"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="15" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.68672e+06" EstimateIO="365.662" EstimateCPU="3.87105" AvgRowSize="114" EstimatedTotalSubtreeCost="653.369" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1212"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.68672e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="114" EstimatedTotalSubtreeCost="110.139" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1212"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1212"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1796]=(0) THEN NULL ELSE [Expr1797] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1796"></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="Expr1797"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.68672e+06" EstimateIO="0" EstimateCPU="22.1631" AvgRowSize="114" EstimatedTotalSubtreeCost="110.139" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1796"></ColumnReference><ColumnReference Column="Expr1797"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1796"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1206])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1206"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1797"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1206])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1206"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.42687e+07" EstimateIO="0" EstimateCPU="14.8506" AvgRowSize="106" EstimatedTotalSubtreeCost="87.9755" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1206"></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="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="19" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.66254" EstimateCPU="0.220443" AvgRowSize="101" EstimatedTotalSubtreeCost="3.88298" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="15" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.3693e+07" EstimateIO="0" EstimateCPU="5.1623" AvgRowSize="20" EstimatedTotalSubtreeCost="69.2418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1206"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1302"></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="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="351.242" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><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="15" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="22" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.18915e+07" EstimateIO="0" EstimateCPU="0.0898644" AvgRowSize="24" EstimatedTotalSubtreeCost="64.031" 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_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1206"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1206"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[web_sales].[ws_ext_list_price]-[TPCDS_SF100].[dbo].[web_sales].[ws_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[web_sales].[ws_ext_discount_amt]+[TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18915e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="45.5282" EstimateCPU="3.95592" AvgRowSize="35" EstimatedTotalSubtreeCost="49.4841" 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_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_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_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="5" 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 [TPCDS_SF100].[dbo].[web_sales].[ws_ext_discount_amt] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_ext_wholesale_cost] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_ext_list_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_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="[web_sales]" Column="ws_ext_discount_amt"></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_ext_sales_price"></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_ext_wholesale_cost"></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_ext_list_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><Predicate><ScalarOperator ScalarString="[Expr1158]&gt;(0.000000)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1158"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="24" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="588279" EstimateIO="0" EstimateCPU="0.121578" AvgRowSize="36" EstimatedTotalSubtreeCost="440.754" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.96093e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="36" EstimatedTotalSubtreeCost="440.633" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1082"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1082"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1802]=(0) THEN NULL ELSE [Expr1803] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1802"></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="Expr1803"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.96093e+06" EstimateIO="0" EstimateCPU="5.54641" AvgRowSize="36" EstimatedTotalSubtreeCost="440.633" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1802"></ColumnReference><ColumnReference Column="Expr1803"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1802"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1214])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1214"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1803"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1214])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1214"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="27" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.92167e+06" EstimateIO="194.487" EstimateCPU="2.05888" AvgRowSize="114" EstimatedTotalSubtreeCost="435.086" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1214"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.92167e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="114" EstimatedTotalSubtreeCost="146.155" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1214"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1214"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1800]=(0) THEN NULL ELSE [Expr1801] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1800"></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="Expr1801"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.92167e+06" EstimateIO="0" EstimateCPU="13.9495" AvgRowSize="114" EstimatedTotalSubtreeCost="146.155" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1800"></ColumnReference><ColumnReference Column="Expr1801"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1800"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1208])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1208"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1801"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1208])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1208"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.81206e+07" EstimateIO="0" EstimateCPU="9.47957" AvgRowSize="106" EstimatedTotalSubtreeCost="132.206" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1208"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1544"></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="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.66254" EstimateCPU="0.220443" AvgRowSize="101" EstimatedTotalSubtreeCost="3.88298" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.6986e+07" EstimateIO="0" EstimateCPU="5.11596" AvgRowSize="20" EstimatedTotalSubtreeCost="118.843" 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="Expr1208"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1545"></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="33" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="351.242" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(1999)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="34" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.42698e+08" EstimateIO="0" EstimateCPU="0.0891863" AvgRowSize="24" EstimatedTotalSubtreeCost="113.679" 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 Column="Expr1208"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1208"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_list_price]-[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_discount_amt]+[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42698e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="91.1879" EstimateCPU="7.92346" AvgRowSize="35" EstimatedTotalSubtreeCost="99.1114" 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_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_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_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_bill_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_discount_amt] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_wholesale_cost] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_list_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_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="[catalog_sales]" Column="cs_ext_discount_amt"></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_ext_sales_price"></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_ext_wholesale_cost"></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_ext_list_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><Predicate><ScalarOperator ScalarString="[Expr1082]&gt;(0.000000)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1082"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp><RelOp NodeId="36" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="589097" EstimateIO="0" EstimateCPU="0.0304367" AvgRowSize="44" EstimatedTotalSubtreeCost="289.613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="37" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.96366e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="44" EstimatedTotalSubtreeCost="289.583" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1806]=(0) THEN NULL ELSE [Expr1807] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1806"></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="Expr1807"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.96366e+06" EstimateIO="0" EstimateCPU="1.35691" AvgRowSize="44" EstimatedTotalSubtreeCost="289.583" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1806"></ColumnReference><ColumnReference Column="Expr1807"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1806"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1210])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1210"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1807"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1210])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1210"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="39" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.92731e+06" EstimateIO="46.5628" EstimateCPU="0.51546" AvgRowSize="109" EstimatedTotalSubtreeCost="288.226" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1210"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="40" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.92731e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="109" EstimatedTotalSubtreeCost="219.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1210"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1210"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1804]=(0) THEN NULL ELSE [Expr1805] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1804"></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="Expr1805"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.92731e+06" EstimateIO="0" EstimateCPU="4.43386" AvgRowSize="109" EstimatedTotalSubtreeCost="219.028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1804"></ColumnReference><ColumnReference Column="Expr1805"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1804"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1204])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1204"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1805"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1204])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1204"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="42" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.22633e+07" EstimateIO="0" EstimateCPU="3.22178" AvgRowSize="101" EstimatedTotalSubtreeCost="214.594" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1204"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1567"></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="43" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.48134" EstimateCPU="0.220443" AvgRowSize="96" EstimatedTotalSubtreeCost="3.70179" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.02616e+07" EstimateIO="0" EstimateCPU="2.36974" AvgRowSize="20" EstimatedTotalSubtreeCost="207.67" 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="Expr1204"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1572"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="351.242" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><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]=(1999)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="46" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.63886e+08" EstimateIO="0" EstimateCPU="0.0412321" AvgRowSize="24" EstimatedTotalSubtreeCost="205.252" 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="Expr1204"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1204"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[store_sales].[ss_ext_list_price]-[TPCDS_SF100].[dbo].[store_sales].[ss_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[store_sales].[ss_ext_discount_amt]+[TPCDS_SF100].[dbo].[store_sales].[ss_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="47" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.63886e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="182.153" EstimateCPU="15.8277" AvgRowSize="35" EstimatedTotalSubtreeCost="197.98" 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_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_ext_discount_amt] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_ext_sales_price] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_ext_wholesale_cost] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_ext_list_price] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_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_ext_discount_amt"></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_ext_sales_price"></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_ext_wholesale_cost"></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_ext_list_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><Predicate><ScalarOperator ScalarString="[Expr1006]&gt;(0.000000)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0.000000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp><RelOp NodeId="48" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.85235e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="36" EstimatedTotalSubtreeCost="72.2758" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1192"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1192"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1810]=(0) THEN NULL ELSE [Expr1811] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1810"></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="Expr1811"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="49" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.85235e+06" EstimateIO="0" EstimateCPU="0.328971" AvgRowSize="36" EstimatedTotalSubtreeCost="72.2758" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1810"></ColumnReference><ColumnReference Column="Expr1811"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1810"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1211])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1211"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1811"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1211])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1211"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="50" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.68967e+06" EstimateIO="11.4447" EstimateCPU="0.121067" AvgRowSize="114" EstimatedTotalSubtreeCost="71.9469" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1211"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="51" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.68967e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="114" EstimatedTotalSubtreeCost="54.9456" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1211"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1211"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1808]=(0) THEN NULL ELSE [Expr1809] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1808"></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="Expr1809"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="52" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.68967e+06" EstimateIO="0" EstimateCPU="0.699446" AvgRowSize="114" EstimatedTotalSubtreeCost="54.9456" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1808"></ColumnReference><ColumnReference Column="Expr1809"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1808"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1205])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1205"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1809"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1205])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1205"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="53" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.47186e+07" EstimateIO="0" EstimateCPU="0.46997" AvgRowSize="106" EstimatedTotalSubtreeCost="54.2461" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1205"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1606"></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="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="54" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.66254" EstimateCPU="0.220443" AvgRowSize="101" EstimatedTotalSubtreeCost="3.88298" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="18" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="55" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.41247e+07" EstimateIO="0" EstimateCPU="0.16443" AvgRowSize="20" EstimatedTotalSubtreeCost="49.8932" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1205"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1611"></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="56" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="362.281" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><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="18" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="57" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.18985e+07" EstimateIO="0" EstimateCPU="0.00280854" AvgRowSize="24" EstimatedTotalSubtreeCost="49.6802" 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_bill_customer_sk"></ColumnReference><ColumnReference Column="Expr1205"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1205"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[web_sales].[ws_ext_list_price]-[TPCDS_SF100].[dbo].[web_sales].[ws_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[web_sales].[ws_ext_discount_amt]+[TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="58" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18985e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="45.5282" EstimateCPU="3.95592" AvgRowSize="35" EstimatedTotalSubtreeCost="49.4841" 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_bill_customer_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_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_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="6" 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"><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></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="59" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.96093e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="36" EstimatedTotalSubtreeCost="123.664" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1116"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1814]=(0) THEN NULL ELSE [Expr1815] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1814"></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="Expr1815"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="60" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.96093e+06" EstimateIO="0" EstimateCPU="0.348316" AvgRowSize="36" EstimatedTotalSubtreeCost="123.664" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Column="Expr1814"></ColumnReference><ColumnReference Column="Expr1815"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1814"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1213])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1213"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1815"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1213])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1213"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="61" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.92173e+06" EstimateIO="12.1639" EstimateCPU="0.128682" AvgRowSize="114" EstimatedTotalSubtreeCost="123.316" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1213"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="62" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.92173e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="114" EstimatedTotalSubtreeCost="105.246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1213"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1213"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1812]=(0) THEN NULL ELSE [Expr1813] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1812"></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="Expr1813"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="63" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.92173e+06" EstimateIO="0" EstimateCPU="0.883315" AvgRowSize="114" EstimatedTotalSubtreeCost="105.246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1812"></ColumnReference><ColumnReference Column="Expr1813"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1812"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1207])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1207"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1813"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1207])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1207"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="64" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.90595e+07" EstimateIO="0" EstimateCPU="0.602835" AvgRowSize="106" EstimatedTotalSubtreeCost="104.363" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1207"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1637"></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="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="65" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.66254" EstimateCPU="0.220443" AvgRowSize="101" EstimatedTotalSubtreeCost="3.88298" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="11" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="66" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.7887e+07" EstimateIO="0" EstimateCPU="0.324384" AvgRowSize="20" EstimatedTotalSubtreeCost="99.877" 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="Expr1207"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1642"></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="67" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="362.281" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><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="11" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(2000)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="68" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.42969e+08" EstimateIO="0" EstimateCPU="0.00558473" AvgRowSize="24" EstimatedTotalSubtreeCost="99.5041" 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 Column="Expr1207"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1207"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_list_price]-[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_discount_amt]+[TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="69" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42969e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="91.1879" EstimateCPU="7.92346" AvgRowSize="35" EstimatedTotalSubtreeCost="99.1114" 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_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_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_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_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></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="70" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.96366e+06" EstimateIO="0" EstimateCPU="9.58816e-06" AvgRowSize="129" EstimatedTotalSubtreeCost="202.613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Expr1040"></ColumnReference><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Union1060"></ColumnReference><ColumnReference Column="Union1062"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1058"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1059"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_first_name]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1060"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_last_name]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1062"></ColumnReference><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_birth_country]"><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="71" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.96366e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="77" EstimatedTotalSubtreeCost="202.613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Expr1040"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1040"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1818]=(0) THEN NULL ELSE [Expr1819] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1818"></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="Expr1819"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="72" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.96366e+06" EstimateIO="0" EstimateCPU="0.0126195" AvgRowSize="77" EstimatedTotalSubtreeCost="202.613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Column="Expr1818"></ColumnReference><ColumnReference Column="Expr1819"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1818"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1215])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1215"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1819"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1215])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1215"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="73" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="3.92731e+06" EstimateIO="0.389257" EstimateCPU="0.00402703" AvgRowSize="114" EstimatedTotalSubtreeCost="202.601" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1215"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DistributionKey><RelOp NodeId="74" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.92731e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="114" EstimatedTotalSubtreeCost="202.023" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="partialagg1215"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1215"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1816]=(0) THEN NULL ELSE [Expr1817] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1816"></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="Expr1817"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="75" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.92731e+06" EstimateIO="0" EstimateCPU="0.0377714" AvgRowSize="114" EstimatedTotalSubtreeCost="202.023" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1816"></ColumnReference><ColumnReference Column="Expr1817"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1816"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1209])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1209"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1817"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1209])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1209"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer].[c_customer_id] = [TPCDS_SF100].[dbo].[customer].[c_customer_id] AND [TPCDS_SF100].[dbo].[customer].[c_first_name] = [TPCDS_SF100].[dbo].[customer].[c_first_name] AND [TPCDS_SF100].[dbo].[customer].[c_last_name] = [TPCDS_SF100].[dbo].[customer].[c_last_name] AND [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] = [TPCDS_SF100].[dbo].[customer].[c_preferred_cust_flag] AND [TPCDS_SF100].[dbo].[customer].[c_birth_country] = [TPCDS_SF100].[dbo].[customer].[c_birth_country] AND [TPCDS_SF100].[dbo].[customer].[c_login] = [TPCDS_SF100].[dbo].[customer].[c_login] AND [TPCDS_SF100].[dbo].[customer].[c_email_address] = [TPCDS_SF100].[dbo].[customer].[c_email_address]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="76" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.48874e+07" EstimateIO="0" EstimateCPU="0.0280601" AvgRowSize="106" EstimatedTotalSubtreeCost="201.986" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Column="Expr1209"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1681"></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="77" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.00388e+06" EstimatedRowsRead="2.00388e+06" EstimateIO="3.66254" EstimateCPU="0.220443" AvgRowSize="101" EstimatedTotalSubtreeCost="3.88298" 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><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></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><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="78" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.27852e+07" EstimateIO="0" EstimateCPU="0.0210824" AvgRowSize="20" EstimatedTotalSubtreeCost="198.074" 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="Expr1209"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1686"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="79" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="362.281" EstimatedRowsRead="73239" EstimateIO="0.0222516" EstimateCPU="0.00807199" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0303236" 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" IsImplicitBroadcast="1"><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]=(2000)"><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></Predicate></IndexScan></RelOp><RelOp NodeId="80" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.68691e+08" EstimateIO="0" EstimateCPU="0.000327992" AvgRowSize="24" EstimatedTotalSubtreeCost="198.005" 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="Expr1209"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1209"></ColumnReference><ScalarOperator ScalarString="([TPCDS_SF100].[dbo].[store_sales].[ss_ext_list_price]-[TPCDS_SF100].[dbo].[store_sales].[ss_ext_wholesale_cost]-[TPCDS_SF100].[dbo].[store_sales].[ss_ext_discount_amt]+[TPCDS_SF100].[dbo].[store_sales].[ss_ext_sales_price])/(2.)"><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_discount_amt"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(2.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="81" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.68691e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="182.153" EstimateCPU="15.8277" AvgRowSize="35" EstimatedTotalSubtreeCost="197.98" 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_ext_discount_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_discount_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_list_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></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></ComputeScalar></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
