<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="&#xa;WITH all_sales AS (&#xa; SELECT d_year&#xa;       ,i_brand_id&#xa;       ,i_class_id&#xa;       ,i_category_id&#xa;       ,i_manufact_id&#xa;       ,SUM(sales_cnt) AS sales_cnt&#xa;       ,SUM(sales_amt) AS sales_amt&#xa; FROM (SELECT d_year&#xa;             ,i_brand_id&#xa;             ,i_class_id&#xa;             ,i_category_id&#xa;             ,i_manufact_id&#xa;             ,cs_quantity - COALESCE(cr_return_quantity,0) AS sales_cnt&#xa;             ,cs_ext_sales_price - COALESCE(cr_return_amount,0.0) AS sales_amt&#xa;       FROM catalog_sales JOIN item ON i_item_sk=cs_item_sk&#xa;                          JOIN date_dim ON d_date_sk=cs_sold_date_sk&#xa;                          LEFT JOIN catalog_returns ON (cs_order_number=cr_order_number&#xa;                                                    AND cs_item_sk=cr_item_sk)&#xa;       WHERE i_category=&apos;Electronics&apos;&#xa;       and cs_sales_price / cs_list_price BETWEEN 80 * 0.01 AND 100 * 0.01&#xa;       and cr_reason_sk in (3, 6, 18, 30, 40)&#xa;       UNION&#xa;       SELECT d_year&#xa;             ,i_brand_id&#xa;             ,i_class_id&#xa;             ,i_category_id&#xa;             ,i_manufact_id&#xa;             ,ss_quantity - COALESCE(sr_return_quantity,0) AS sales_cnt&#xa;             ,ss_ext_sales_price - COALESCE(sr_return_amt,0.0) AS sales_amt&#xa;       FROM store_sales JOIN item ON i_item_sk=ss_item_sk&#xa;                        JOIN date_dim ON d_date_sk=ss_sold_date_sk&#xa;                        LEFT JOIN store_returns ON (ss_ticket_number=sr_ticket_number&#xa;                                                AND ss_item_sk=sr_item_sk)&#xa;       WHERE i_category=&apos;Electronics&apos;&#xa;       and ss_sales_price / ss_list_price BETWEEN 80 * 0.01 AND 100 * 0.01&#xa;       and sr_reason_sk in (3, 6, 18, 30, 40)&#xa;       UNION&#xa;       SELECT d_year&#xa;             ,i_brand_id&#xa;             ,i_class_id&#xa;             ,i_category_id&#xa;             ,i_manufact_id&#xa;             ,ws_quantity - COALESCE(wr_return_quantity,0) AS sales_cnt&#xa;             ,ws_ext_sales_price - COALESCE(wr_return_amt,0.0) AS sales_amt&#xa;       FROM web_sales JOIN item ON i_item_sk=ws_item_sk&#xa;                      JOIN date_dim ON d_date_sk=ws_sold_date_sk&#xa;                      LEFT JOIN web_returns ON (ws_order_number=wr_order_number&#xa;                                            AND ws_item_sk=wr_item_sk)&#xa;       WHERE i_category=&apos;Electronics&apos;&#xa;       and ws_sales_price / ws_list_price BETWEEN 80 * 0.01 AND 100 * 0.01&#xa;       and wr_reason_sk in (3, 6, 18, 30, 40)) sales_detail&#xa;GROUP BY d_year, i_brand_id, i_class_id, i_category_id, i_manufact_id)&#xa; SELECT top 100 prev_yr.d_year AS prev_year&#xa;                          ,curr_yr.d_year AS year&#xa;                          ,curr_yr.i_brand_id&#xa;                          ,curr_yr.i_class_id&#xa;                          ,curr_yr.i_category_id&#xa;                          ,curr_yr.i_manufact_id&#xa;                          ,prev_yr.sales_cnt AS prev_yr_cnt&#xa;                          ,curr_yr.sales_cnt AS curr_yr_cnt&#xa;                          ,curr_yr.sales_cnt-prev_yr.sales_cnt AS sales_cnt_diff&#xa;                          ,curr_yr.sales_amt-prev_yr.sales_amt AS sales_amt_diff&#xa; FROM all_sales curr_yr, all_sales prev_yr&#xa; WHERE curr_yr.i_brand_id=prev_yr.i_brand_id&#xa;   AND curr_yr.i_class_id=prev_yr.i_class_id&#xa;   AND curr_yr.i_category_id=prev_yr.i_category_id&#xa;   AND curr_yr.i_manufact_id=prev_yr.i_manufact_id&#xa;   AND curr_yr.d_year=2000&#xa;   AND prev_yr.d_year=2000-1&#xa;   AND prev_yr.sales_cnt &gt; 0&#xa;   AND CAST(curr_yr.sales_cnt AS DECIMAL(17,2))/CAST(prev_yr.sales_cnt AS DECIMAL(17,2))&lt;0.9&#xa; ORDER BY sales_cnt_diff,sales_amt_diff" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="1186.11" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x9F872C913D9F3080" QueryPlanHash="0xEA56A1C4813B0F01" 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="1432" CompileTime="835" CompileCPU="835" CompileMemory="47792"><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-03T18:33:48.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:08.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:18.77" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:39.54" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:54.43" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:07.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.00" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:52.23" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000013_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:17.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:12.08" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000015_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:13.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000016_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:53.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:11.52" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000013_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.27" ModificationCount="0" SamplingPercent="73.9589" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:11.05" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:50.50" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:10.82" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:38.36" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:55.49" ModificationCount="0" SamplingPercent="26.4701" Statistics="[_WA_Sys_00000001_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:01.35" ModificationCount="0" SamplingPercent="26.7429" Statistics="[_WA_Sys_0000000A_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:33.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000018_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:05.14" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.23" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:02.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:51.56" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000013_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:01.53" ModificationCount="0" SamplingPercent="26.9393" Statistics="[_WA_Sys_00000008_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:25.89" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000A_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:16.77" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:13.96" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000015_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:39.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000F_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.25" ModificationCount="0" SamplingPercent="26.6265" Statistics="[_WA_Sys_0000000D_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:15.81" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:01.16" ModificationCount="0" SamplingPercent="26.7002" Statistics="[_WA_Sys_0000000C_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:40.38" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:06.56" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:25.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:03.54" ModificationCount="0" SamplingPercent="26.423" Statistics="[_WA_Sys_0000000E_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:17.04" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:46.05" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000018_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:24.43" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000A_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:14.68" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000016_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="5e-06" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.11" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1030"></ColumnReference><ScalarOperator ScalarString="[Union1030]"><Identifier><ColumnReference Column="Union1030"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1031"></ColumnReference><ScalarOperator ScalarString="[Union1031]"><Identifier><ColumnReference Column="Union1031"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1032"></ColumnReference><ScalarOperator ScalarString="[Union1032]"><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1033"></ColumnReference><ScalarOperator ScalarString="[Union1033]"><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1034"></ColumnReference><ScalarOperator ScalarString="[Union1034]"><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1037"></ColumnReference><ScalarOperator ScalarString="[Expr1037]"><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1069"></ColumnReference><ScalarOperator ScalarString="[Union1069]"><Identifier><ColumnReference Column="Union1069"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1076"></ColumnReference><ScalarOperator ScalarString="[Expr1076]"><Identifier><ColumnReference Column="Expr1076"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1078"></ColumnReference><ScalarOperator ScalarString="[Expr1078]"><Identifier><ColumnReference Column="Expr1078"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1079"></ColumnReference><ScalarOperator ScalarString="[Expr1079]"><Identifier><ColumnReference Column="Expr1079"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="5e-06" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.11" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.000305558" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.11" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1078"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1079"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0.023125" EstimateCPU="0.00021" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.11" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00281532" EstimateCPU="0.00396691" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1078"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1079"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2892.93" EstimateIO="0" EstimateCPU="1.44646e-05" AvgRowSize="61" EstimatedTotalSubtreeCost="1186.07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1078"></ColumnReference><ColumnReference Column="Expr1079"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1078"></ColumnReference><ScalarOperator ScalarString="[Expr1037]-[Expr1076]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1076"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1079"></ColumnReference><ScalarOperator ScalarString="[Expr1038]-[Expr1077]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1038"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1077"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2892.93" EstimateIO="0" EstimateCPU="0.0437752" AvgRowSize="74" EstimatedTotalSubtreeCost="1186.07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Expr1038"></ColumnReference><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1077"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1246"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1031]=[Union1070] AND [Union1032]=[Union1071] AND [Union1033]=[Union1072] AND [Union1034]=[Union1073] AND CONVERT(decimal(17,2),[Expr1037],0)/CONVERT(decimal(17,2),[Expr1076],0)&lt;(0.9)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Convert DataType="decimal" Precision="17" Scale="2" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="17" Scale="2" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Column="Expr1076"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.9)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="12045.4" EstimateIO="0" EstimateCPU="0.00497876" AvgRowSize="48" EstimatedTotalSubtreeCost="593.088" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1077"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="40151.3" EstimateIO="0" EstimateCPU="0" AvgRowSize="48" EstimatedTotalSubtreeCost="593.083" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Expr1076"></ColumnReference><ColumnReference Column="Expr1077"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1076"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2126]=(0) THEN NULL ELSE [Expr2127] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2126"></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="Expr2127"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1077"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2128]=(0) THEN NULL ELSE [Expr2129] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2128"></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="Expr2129"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="40151.3" EstimateIO="0" EstimateCPU="0.100988" AvgRowSize="48" EstimatedTotalSubtreeCost="593.083" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Expr2126"></ColumnReference><ColumnReference Column="Expr2127"></ColumnReference><ColumnReference Column="Expr2128"></ColumnReference><ColumnReference Column="Expr2129"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr2126"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1074])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2127"></ColumnReference><ScalarOperator ScalarString="SUM([Union1074])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2128"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1075])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2129"></ColumnReference><ScalarOperator ScalarString="SUM([Union1075])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1069"></ColumnReference><ScalarOperator ScalarString="ANY([Union1069])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1070] = [Union1070] AND [Union1071] = [Union1071] AND [Union1072] = [Union1072] AND [Union1073] = [Union1073]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="45705.3" EstimateIO="0" EstimateCPU="0.122786" AvgRowSize="36" EstimatedTotalSubtreeCost="592.982" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Union1069"></ColumnReference><ScalarOperator ScalarString="ANY([Union1069])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1070] = [Union1070] AND [Union1071] = [Union1071] AND [Union1072] = [Union1072] AND [Union1073] = [Union1073] AND [Union1074] = [Union1074] AND [Union1075] = [Union1075]"><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 Column="Union1070"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="12" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="45705.5" EstimateIO="1.44039" EstimateCPU="0.0479908" AvgRowSize="36" EstimatedTotalSubtreeCost="592.859" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference></DistributionKey><RelOp NodeId="13" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="45705.5" EstimateIO="0" EstimateCPU="0.000228528" AvgRowSize="36" EstimatedTotalSubtreeCost="590.678" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1069"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="9027.51" EstimateIO="0" EstimateCPU="4.51376e-05" AvgRowSize="36" EstimatedTotalSubtreeCost="130.034" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1047"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_quantity]-[Expr1089]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]-[Expr1090]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1090"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="9027.51" EstimateIO="0" EstimateCPU="1.82818" AvgRowSize="46" EstimatedTotalSubtreeCost="130.034" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1361"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_order_number]=[DSB_SF100].[dbo].[catalog_returns].[cr_order_number] AND [DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[catalog_returns].[cr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="897062" EstimateIO="0" EstimateCPU="0.371689" AvgRowSize="45" EstimatedTotalSubtreeCost="114.624" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1372"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.208116" EstimateCPU="0.0223617" AvgRowSize="56" EstimatedTotalSubtreeCost="0.230477" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="3.99513e+06" EstimateIO="0" EstimateCPU="0.417057" AvgRowSize="28" EstimatedTotalSubtreeCost="113.62" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1374"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(1999)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="21" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="2.36661e+07" EstimateIO="0" EstimateCPU="6.11982" AvgRowSize="28" EstimatedTotalSubtreeCost="113.155" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.36661e+07" EstimatedRowsRead="1.44208e+08" EstimateIO="99.1036" EstimateCPU="7.93144" AvgRowSize="38" EstimatedTotalSubtreeCost="107.035" TableCardinality="1.44208e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_sales_price]/[DSB_SF100].[dbo].[catalog_sales].[cs_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[catalog_sales].[cs_sales_price]/[DSB_SF100].[dbo].[catalog_sales].[cs_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.6145e+06" EstimateIO="0" EstimateCPU="0.000204258" AvgRowSize="24" EstimatedTotalSubtreeCost="13.5813" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference><ColumnReference Column="Expr1090"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1090"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.6145e+06" EstimatedRowsRead="2.1652e+07" EstimateIO="10.9662" EstimateCPU="2.38174" AvgRowSize="28" EstimatedTotalSubtreeCost="13.348" TableCardinality="2.1652e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(3) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(6) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(18) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(30) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(40)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="30753.8" EstimateIO="0" EstimateCPU="0.000153769" AvgRowSize="36" EstimatedTotalSubtreeCost="393.215" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_quantity]-[Expr1092]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1092"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price]-[Expr1093]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1093"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="30753.8" EstimateIO="0" EstimateCPU="0.0912308" AvgRowSize="46" EstimatedTotalSubtreeCost="393.215" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1092"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1387"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="27" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="42112.3" EstimateIO="2.64621" EstimateCPU="0.0884569" AvgRowSize="27" EstimatedTotalSubtreeCost="3.93184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.208116" EstimateCPU="0.0111808" AvgRowSize="56" EstimatedTotalSubtreeCost="0.219296" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="56625.8" EstimateIO="0" EstimateCPU="5.82738" AvgRowSize="33" EstimatedTotalSubtreeCost="389.192" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Column="Expr1092"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1419"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_ticket_number]=[DSB_SF100].[dbo].[store_returns].[sr_ticket_number] AND [DSB_SF100].[dbo].[store_sales].[ss_item_sk]=[DSB_SF100].[dbo].[store_returns].[sr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="31" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1.9374e+06" EstimateIO="89.7784" EstimateCPU="4.51422" AvgRowSize="24" EstimatedTotalSubtreeCost="168.713" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Column="Expr1092"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="32" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.9374e+06" EstimateIO="0" EstimateCPU="0.0107481" AvgRowSize="24" EstimatedTotalSubtreeCost="53.0339" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Column="Expr1092"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1092"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1093"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="34" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.9374e+06" EstimatedRowsRead="7.22732e+07" EstimateIO="36.5991" EstimateCPU="3.97503" AvgRowSize="28" EstimatedTotalSubtreeCost="40.5741" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(3) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(6) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(18) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(30) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(40)) AND PROBE([Opt_Bitmap1387],[DSB_SF100].[dbo].[store_returns].[sr_item_sk])"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1387"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Move></RelOp><RelOp NodeId="35" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.17648e+06" EstimateIO="0" EstimateCPU="0.0280341" AvgRowSize="28" EstimatedTotalSubtreeCost="214.651" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1422"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(1999)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="37" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="4.6874e+07" EstimateIO="0" EstimateCPU="0.382711" AvgRowSize="28" EstimatedTotalSubtreeCost="214.575" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="38" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.6874e+07" EstimatedRowsRead="2.88583e+08" EstimateIO="198.32" EstimateCPU="15.8721" AvgRowSize="38" EstimatedTotalSubtreeCost="214.192" TableCardinality="2.88583e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sales_price]/[DSB_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[store_sales].[ss_sales_price]/[DSB_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="39" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5924.22" EstimateIO="0" EstimateCPU="2.96211e-05" AvgRowSize="36" EstimatedTotalSubtreeCost="67.4284" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1067"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_quantity]-[Expr1095]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1095"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1068"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_ext_sales_price]-[Expr1096]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1096"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="40" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5924.22" EstimateIO="0" EstimateCPU="0.905219" AvgRowSize="46" EstimatedTotalSubtreeCost="67.4284" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1095"></ColumnReference><ColumnReference Column="Expr1096"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1605"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_order_number]=[DSB_SF100].[dbo].[web_returns].[wr_order_number] AND [DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[web_returns].[wr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="442661" EstimateIO="0" EstimateCPU="0.223062" AvgRowSize="45" EstimatedTotalSubtreeCost="57.4886" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1617"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="43" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.208116" EstimateCPU="0.0223617" AvgRowSize="56" EstimatedTotalSubtreeCost="0.230477" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.00483e+06" EstimateIO="0" EstimateCPU="0.20936" AvgRowSize="28" EstimatedTotalSubtreeCost="56.6332" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1612"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(1999)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="Filter" LogicalOp="Filter" EstimateRows="1.18046e+07" EstimateIO="0" EstimateCPU="3.04892" AvgRowSize="28" EstimatedTotalSubtreeCost="56.3754" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="47" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.18046e+07" EstimatedRowsRead="7.1845e+07" EstimateIO="49.375" EstimateCPU="3.95148" AvgRowSize="38" EstimatedTotalSubtreeCost="53.3265" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_sales_price]/[DSB_SF100].[dbo].[web_sales].[ws_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[web_sales].[ws_sales_price]/[DSB_SF100].[dbo].[web_sales].[ws_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="48" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.68817e+06" EstimateIO="0" EstimateCPU="0.000131889" AvgRowSize="24" EstimatedTotalSubtreeCost="9.03453" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Column="Expr1095"></ColumnReference><ColumnReference Column="Expr1096"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1095"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1096"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="49" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.68817e+06" EstimatedRowsRead="1.44021e+07" EstimateIO="7.29511" EstimateCPU="1.58425" AvgRowSize="28" EstimatedTotalSubtreeCost="8.87935" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(3) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(6) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(18) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(30) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(40)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Concat></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1076]&gt;(0)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1076"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="50" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39671.2" EstimateIO="0" EstimateCPU="0" AvgRowSize="48" EstimatedTotalSubtreeCost="592.935" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr1037"></ColumnReference><ColumnReference Column="Expr1038"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1037"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2130]=(0) THEN NULL ELSE [Expr2131] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2130"></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="Expr2131"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1038"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr2132]=(0) THEN NULL ELSE [Expr2133] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr2132"></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="Expr2133"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="51" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39671.2" EstimateIO="0" EstimateCPU="0.0997751" AvgRowSize="48" EstimatedTotalSubtreeCost="592.935" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Expr2130"></ColumnReference><ColumnReference Column="Expr2131"></ColumnReference><ColumnReference Column="Expr2132"></ColumnReference><ColumnReference Column="Expr2133"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr2130"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1035])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2131"></ColumnReference><ScalarOperator ScalarString="SUM([Union1035])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2132"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1036])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr2133"></ColumnReference><ScalarOperator ScalarString="SUM([Union1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1030"></ColumnReference><ScalarOperator ScalarString="ANY([Union1030])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1031] = [Union1031] AND [Union1032] = [Union1032] AND [Union1033] = [Union1033] AND [Union1034] = [Union1034]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1031"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="52" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="45079.1" EstimateIO="0" EstimateCPU="0.121129" AvgRowSize="36" EstimatedTotalSubtreeCost="592.836" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Union1030"></ColumnReference><ScalarOperator ScalarString="ANY([Union1030])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1031] = [Union1031] AND [Union1032] = [Union1032] AND [Union1033] = [Union1033] AND [Union1034] = [Union1034] AND [Union1035] = [Union1035] AND [Union1036] = [Union1036]"><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 Column="Union1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1031"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1032"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1033"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1034"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1035"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1036"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="53" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="45079.4" EstimateIO="1.42078" EstimateCPU="0.0473334" AvgRowSize="36" EstimatedTotalSubtreeCost="592.714" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference></DistributionKey><RelOp NodeId="54" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="45079.4" EstimateIO="0" EstimateCPU="0.000225397" AvgRowSize="36" EstimatedTotalSubtreeCost="590.563" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Union1036"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1030"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1031"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1032"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1033"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1034"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1035"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1036"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="55" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8903.85" EstimateIO="0" EstimateCPU="4.45192e-05" AvgRowSize="36" EstimatedTotalSubtreeCost="129.934" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_quantity]-[Expr1080]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1080"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]-[Expr1081]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1081"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="56" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8903.85" EstimateIO="0" EstimateCPU="1.80334" AvgRowSize="46" EstimatedTotalSubtreeCost="129.934" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1080"></ColumnReference><ColumnReference Column="Expr1081"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1740"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_order_number]=[DSB_SF100].[dbo].[catalog_returns].[cr_order_number] AND [DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[catalog_returns].[cr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="57" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="884774" EstimateIO="0" EstimateCPU="0.367618" AvgRowSize="45" EstimatedTotalSubtreeCost="114.549" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1751"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="59" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.138314" EstimateCPU="0.0223617" AvgRowSize="37" EstimatedTotalSubtreeCost="0.160676" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="60" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="3.9404e+06" EstimateIO="0" EstimateCPU="0.416003" AvgRowSize="28" EstimatedTotalSubtreeCost="113.619" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1753"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="61" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="359.375" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2000)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="62" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="2.36661e+07" EstimateIO="0" EstimateCPU="6.11982" AvgRowSize="28" EstimatedTotalSubtreeCost="113.155" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="63" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.36661e+07" EstimatedRowsRead="1.44208e+08" EstimateIO="99.1036" EstimateCPU="7.93144" AvgRowSize="38" EstimatedTotalSubtreeCost="107.035" TableCardinality="1.44208e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_sales_price]/[DSB_SF100].[dbo].[catalog_sales].[cs_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[catalog_sales].[cs_sales_price]/[DSB_SF100].[dbo].[catalog_sales].[cs_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="64" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.6145e+06" EstimateIO="0" EstimateCPU="0.000204258" AvgRowSize="24" EstimatedTotalSubtreeCost="13.5813" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Column="Expr1080"></ColumnReference><ColumnReference Column="Expr1081"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1080"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1081"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="65" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.6145e+06" EstimatedRowsRead="2.1652e+07" EstimateIO="10.9662" EstimateCPU="2.38174" AvgRowSize="28" EstimatedTotalSubtreeCost="13.348" TableCardinality="2.1652e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(3) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(6) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(18) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(30) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(40)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="66" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="30332.5" EstimateIO="0" EstimateCPU="0.000151663" AvgRowSize="36" EstimatedTotalSubtreeCost="393.215" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_quantity]-[Expr1083]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1083"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price]-[Expr1084]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1084"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="67" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="30332.5" EstimateIO="0" EstimateCPU="0.0910017" AvgRowSize="46" EstimatedTotalSubtreeCost="393.214" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1766"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="68" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="42112.3" EstimateIO="2.64621" EstimateCPU="0.0884569" AvgRowSize="27" EstimatedTotalSubtreeCost="3.93184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="70" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.208116" EstimateCPU="0.0111808" AvgRowSize="56" EstimatedTotalSubtreeCost="0.219296" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Move></RelOp><RelOp NodeId="71" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="55850.1" EstimateIO="0" EstimateCPU="5.827" AvgRowSize="33" EstimatedTotalSubtreeCost="389.192" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1798"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_ticket_number]=[DSB_SF100].[dbo].[store_returns].[sr_ticket_number] AND [DSB_SF100].[dbo].[store_sales].[ss_item_sk]=[DSB_SF100].[dbo].[store_returns].[sr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="72" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="1.9374e+06" EstimateIO="89.7784" EstimateCPU="4.51422" AvgRowSize="24" EstimatedTotalSubtreeCost="168.713" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="73" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.9374e+06" EstimateIO="0" EstimateCPU="0.0107481" AvgRowSize="24" EstimatedTotalSubtreeCost="53.0339" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Column="Expr1083"></ColumnReference><ColumnReference Column="Expr1084"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1083"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1084"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="75" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.9374e+06" EstimatedRowsRead="7.22732e+07" EstimateIO="36.5991" EstimateCPU="3.97503" AvgRowSize="28" EstimatedTotalSubtreeCost="40.5741" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(3) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(6) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(18) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(30) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(40)) AND PROBE([Opt_Bitmap1766],[DSB_SF100].[dbo].[store_returns].[sr_item_sk])"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1766"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Move></RelOp><RelOp NodeId="76" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.06447e+06" EstimateIO="0" EstimateCPU="0.0279613" AvgRowSize="28" EstimatedTotalSubtreeCost="214.651" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1801"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="77" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="359.375" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2000)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="78" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="4.6874e+07" EstimateIO="0" EstimateCPU="0.382711" AvgRowSize="28" EstimatedTotalSubtreeCost="214.575" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="79" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.6874e+07" EstimatedRowsRead="2.88583e+08" EstimateIO="198.32" EstimateCPU="15.8721" AvgRowSize="38" EstimatedTotalSubtreeCost="214.192" TableCardinality="2.88583e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_sales_price]/[DSB_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[store_sales].[ss_sales_price]/[DSB_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="80" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5843.06" EstimateIO="0" EstimateCPU="2.92153e-05" AvgRowSize="36" EstimatedTotalSubtreeCost="67.4136" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_quantity]-[Expr1086]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1086"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_ext_sales_price]-[Expr1087]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1087"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="81" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5843.06" EstimateIO="0" EstimateCPU="0.892961" AvgRowSize="46" EstimatedTotalSubtreeCost="67.4136" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1086"></ColumnReference><ColumnReference Column="Expr1087"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1984"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_order_number]=[DSB_SF100].[dbo].[web_returns].[wr_order_number] AND [DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[web_returns].[wr_item_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="82" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="436598" EstimateIO="0" EstimateCPU="0.221027" AvgRowSize="45" EstimatedTotalSubtreeCost="57.486" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1996"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="84" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="42112.3" EstimatedRowsRead="203145" EstimateIO="0.208116" EstimateCPU="0.0223617" AvgRowSize="56" EstimatedTotalSubtreeCost="0.230477" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; AND [DSB_SF100].[dbo].[item].[i_brand_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_class_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_category_id] IS NOT NULL AND [DSB_SF100].[dbo].[item].[i_manufact_id] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_brand_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manufact_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="85" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.97736e+06" EstimateIO="0" EstimateCPU="0.208829" AvgRowSize="28" EstimatedTotalSubtreeCost="56.6327" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1991"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="86" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="359.375" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2000)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="87" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.18046e+07" EstimateIO="0" EstimateCPU="3.04892" AvgRowSize="28" EstimatedTotalSubtreeCost="56.3754" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="88" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.18046e+07" EstimatedRowsRead="7.1845e+07" EstimateIO="49.375" EstimateCPU="3.95148" AvgRowSize="38" EstimatedTotalSubtreeCost="53.3265" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_sales_price]/[DSB_SF100].[dbo].[web_sales].[ws_list_price]&gt;=(0.80) AND [DSB_SF100].[dbo].[web_sales].[ws_sales_price]/[DSB_SF100].[dbo].[web_sales].[ws_list_price]&lt;=(1.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0.80)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(1.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="89" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.68817e+06" EstimateIO="0" EstimateCPU="0.000131889" AvgRowSize="24" EstimatedTotalSubtreeCost="9.03453" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Column="Expr1086"></ColumnReference><ColumnReference Column="Expr1087"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1086"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_return_quantity] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_return_quantity] ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1087"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="90" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.68817e+06" EstimatedRowsRead="1.44021e+07" EstimateIO="7.29511" EstimateCPU="1.58425" AvgRowSize="28" EstimatedTotalSubtreeCost="8.87935" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(3) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(6) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(18) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(30) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(40)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Concat></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
