<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH customer_total_return AS (&#xa;  SELECT&#xa;    wr_returning_customer_sk AS ctr_customer_sk,&#xa;    ca_state AS ctr_state,&#xa;    wr_reason_sk AS ctr_reason_sk,&#xa;    SUM(wr_return_amt) AS ctr_total_return&#xa;  FROM web_returns, date_dim, customer_address, item&#xa;  WHERE&#xa;    wr_returned_date_sk = d_date_sk&#xa;    AND d_year = 2000&#xa;    AND wr_returning_addr_sk = ca_address_sk&#xa;    AND wr_item_sk = i_item_sk&#xa;    AND i_manager_id BETWEEN 91 AND 100&#xa;    AND wr_return_amt / wr_return_quantity BETWEEN 271 AND 300&#xa;  GROUP BY&#xa;    wr_returning_customer_sk,&#xa;    ca_state,&#xa;    wr_reason_sk&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  c_customer_id,&#xa;  c_salutation,&#xa;  c_first_name,&#xa;  c_last_name,&#xa;  c_preferred_cust_flag,&#xa;  c_birth_day,&#xa;  c_birth_month,&#xa;  c_birth_year,&#xa;  c_birth_country,&#xa;  c_login,&#xa;  c_email_address,&#xa;  c_last_review_date,&#xa;  ctr_total_return&#xa;FROM customer_total_return AS ctr1, customer_address, customer&#xa;WHERE&#xa;  ctr1.ctr_total_return &gt; (&#xa;    SELECT&#xa;      AVG(ctr_total_return) * 1.2&#xa;    FROM customer_total_return AS ctr2&#xa;    WHERE&#xa;      ctr1.ctr_state = ctr2.ctr_state&#xa;  )&#xa;  AND ca_address_sk = c_current_addr_sk&#xa;  AND ca_state IN (&apos;AR&apos;, &apos;GA&apos;, &apos;IL&apos;, &apos;TX&apos;)&#xa;  AND ctr1.ctr_customer_sk = c_customer_sk&#xa;  AND ctr1.ctr_reason_sk IN (15, 50)&#xa;  AND c_birth_year BETWEEN 1987 AND 1993&#xa;ORDER BY&#xa;  c_customer_id,&#xa;  c_salutation,&#xa;  c_first_name,&#xa;  c_last_name,&#xa;  c_preferred_cust_flag,&#xa;  c_birth_day,&#xa;  c_birth_month,&#xa;  c_birth_year,&#xa;  c_birth_country,&#xa;  c_login,&#xa;  c_email_address,&#xa;  c_last_review_date,&#xa;  ctr_total_return" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="31.2863" StatementEstRows="54.4906" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3696CFC367895A75" QueryPlanHash="0xC9A1E92A38F79EF9" 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="560" CompileTime="96" CompileCPU="96" CompileMemory="10648"><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:39.54" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.83" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_797309D9]" Table="[customer]" 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-03T15:57:50.46" ModificationCount="0" SamplingPercent="26.7458" Statistics="[_WA_Sys_00000015_76969D2E]" Table="[item]" 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:33:39.17" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:38.80" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_02084FDA]" Table="[web_returns]" 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-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:58:06.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:52.78" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:56.57" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_6EF57B66]" Table="[customer_address]" 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:33:38.01" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:49.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="54.4906" EstimateIO="0" EstimateCPU="5.44906e-06" AvgRowSize="141" EstimatedTotalSubtreeCost="31.2863" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_customer_id]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_salutation]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_first_name]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_last_name]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_preferred_cust_flag]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_day]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_month]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_year]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_country]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_login]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_email_address]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_last_review_date]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="54.4906" EstimateIO="0" EstimateCPU="5.44906e-06" AvgRowSize="141" EstimatedTotalSubtreeCost="31.2863" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="54.4906" EstimateIO="0.00563063" EstimateCPU="0.000223757" AvgRowSize="141" EstimatedTotalSubtreeCost="31.2863" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1008"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="54.4906" EstimateIO="0" EstimateCPU="0.00195509" AvgRowSize="141" EstimatedTotalSubtreeCost="31.2804" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state]=[DSB_SF100].[dbo].[customer_address].[ca_state] AND [Expr1008]&gt;[Expr1022]*(1.2)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Column="Expr1022"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1.2)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="50.9994" EstimateIO="0" EstimateCPU="0" AvgRowSize="29" EstimatedTotalSubtreeCost="12.8576" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1071]=(0) THEN NULL ELSE [Expr1072]/CONVERT_IMPLICIT(decimal(19,0),[Expr1071],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1072"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="50.9994" EstimateIO="0" EstimateCPU="0.015247" AvgRowSize="29" EstimatedTotalSubtreeCost="12.8576" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1072"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1021])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1072"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1021])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state] = [DSB_SF100].[dbo].[customer_address].[ca_state]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="19954.8" EstimateIO="0" EstimateCPU="0" AvgRowSize="29" EstimatedTotalSubtreeCost="12.8423" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1069]=(0) THEN NULL ELSE [Expr1070] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1069"></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="Expr1070"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19954.8" EstimateIO="0" EstimateCPU="0.075696" AvgRowSize="29" EstimatedTotalSubtreeCost="12.8423" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1069"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1069"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1070"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_returning_customer_sk] = [DSB_SF100].[dbo].[web_returns].[wr_returning_customer_sk] AND [DSB_SF100].[dbo].[customer_address].[ca_state] = [DSB_SF100].[dbo].[customer_address].[ca_state] AND [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] = [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="19954.8" EstimateIO="0" EstimateCPU="0.0945616" AvgRowSize="25" EstimatedTotalSubtreeCost="12.7666" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1041"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="36757.1" EstimateIO="0" EstimateCPU="0.0434169" AvgRowSize="24" EstimatedTotalSubtreeCost="12.2169" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1043"></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_returns]" Column="wr_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="19465.6" EstimatedRowsRead="203145" EstimateIO="0.0574909" EstimateCPU="0.0223617" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0798525" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></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></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_manager_id]&gt;=(91) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(91)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="347057" EstimateIO="0" EstimateCPU="0.0387016" AvgRowSize="28" EstimatedTotalSubtreeCost="11.9538" 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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1039"></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_returns]" Column="wr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" 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></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></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="14" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="2.3259e+06" EstimateIO="0" EstimateCPU="0.903731" AvgRowSize="32" EstimatedTotalSubtreeCost="11.8667" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.3259e+06" EstimatedRowsRead="1.44021e+07" EstimateIO="9.37874" EstimateCPU="1.58425" AvgRowSize="36" EstimatedTotalSubtreeCost="10.963" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></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"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></DefinedValue><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_returning_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></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_returned_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_returns].[wr_returning_addr_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></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="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[web_returns].[wr_return_quantity],0)&gt;=(271.0000000000000) AND [DSB_SF100].[dbo].[web_returns].[wr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[web_returns].[wr_return_quantity],0)&lt;=(300.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(271.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(300.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="971490" EstimatedRowsRead="1.00092e+06" EstimateIO="0.292002" EstimateCPU="0.110117" AvgRowSize="16" EstimatedTotalSubtreeCost="0.402119" TableCardinality="1.00092e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state] IS NOT NULL AND [DSB_SF100].[dbo].[customer_address].[ca_state] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></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="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="52.8885" EstimateIO="0" EstimateCPU="0.00369207" AvgRowSize="145" EstimatedTotalSubtreeCost="18.4207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1044"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="247.792" EstimateIO="0" EstimateCPU="0.00636876" AvgRowSize="149" EstimatedTotalSubtreeCost="18.0132" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1045"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2108.67" EstimateIO="0" EstimateCPU="0" AvgRowSize="34" EstimatedTotalSubtreeCost="13.0091" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1073]=(0) THEN NULL ELSE [Expr1074] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1073"></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="Expr1074"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2108.67" EstimateIO="0" EstimateCPU="0.00958642" AvgRowSize="34" EstimatedTotalSubtreeCost="13.0091" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Column="Expr1073"></ColumnReference><ColumnReference Column="Expr1074"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1073"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1074"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_returning_customer_sk] = [DSB_SF100].[dbo].[web_returns].[wr_returning_customer_sk] AND [DSB_SF100].[dbo].[customer_address].[ca_state] = [DSB_SF100].[dbo].[customer_address].[ca_state] AND [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] = [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2108.67" EstimateIO="0" EstimateCPU="0.00860893" AvgRowSize="26" EstimatedTotalSubtreeCost="12.9995" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1062"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="23" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2858.28" EstimateIO="0" EstimateCPU="0.0225162" AvgRowSize="24" EstimatedTotalSubtreeCost="12.5673" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1065"></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_returns]" Column="wr_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="19465.6" EstimatedRowsRead="203145" EstimateIO="0.0574909" EstimateCPU="0.0223617" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0798525" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></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></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_manager_id]&gt;=(91) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(91)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="25" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="26987.6" EstimateIO="0" EstimateCPU="0.00496961" AvgRowSize="28" EstimatedTotalSubtreeCost="12.3251" 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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1057"></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_returns]" Column="wr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="26" 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></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></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="27" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="180865" EstimateIO="0" EstimateCPU="1.30879" AvgRowSize="32" EstimatedTotalSubtreeCost="12.2718" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="180865" EstimatedRowsRead="1.44021e+07" EstimateIO="9.37874" EstimateCPU="1.58425" AvgRowSize="36" EstimatedTotalSubtreeCost="10.963" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><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_returning_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></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"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></DefinedValue><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_returning_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_reason_sk"></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_returned_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_returns].[wr_returning_customer_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_returns].[wr_returning_addr_sk] IS NOT NULL AND ([DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(15) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(50))"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></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="[web_returns]" Column="wr_returning_customer_sk"></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="[web_returns]" Column="wr_returning_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><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="(15)"></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="(50)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[web_returns].[wr_return_quantity],0)&gt;=(271.0000000000000) AND [DSB_SF100].[dbo].[web_returns].[wr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[web_returns].[wr_return_quantity],0)&lt;=(300.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(271.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(300.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="30" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="971490" EstimatedRowsRead="1.00092e+06" EstimateIO="0.310103" EstimateCPU="0.110117" AvgRowSize="17" EstimatedTotalSubtreeCost="0.42022" TableCardinality="1.00092e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state] IS NOT NULL AND [DSB_SF100].[dbo].[customer_address].[ca_state] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></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="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="156953" EstimatedRowsRead="1.99897e+06" EstimateIO="4.77423" EstimateCPU="0.219902" AvgRowSize="132" EstimatedTotalSubtreeCost="4.99413" TableCardinality="1.99897e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_salutation"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_first_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_preferred_cust_flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_day"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_login"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_email_address"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_last_review_date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_year]&gt;=(1987) AND [DSB_SF100].[dbo].[customer].[c_birth_year]&lt;=(1993) AND [DSB_SF100].[dbo].[customer].[c_current_addr_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1987)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1993)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="33" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="183331" EstimatedRowsRead="1.00092e+06" EstimateIO="0.292002" EstimateCPU="0.110117" AvgRowSize="16" EstimatedTotalSubtreeCost="0.402119" TableCardinality="1.00092e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;AR&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;GA&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;IL&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;TX&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;AR&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;GA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IL&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;TX&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
