<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 sr_items as&#xa; (select i_item_id item_id,&#xa;        sum(sr_return_quantity) sr_item_qty&#xa; from store_returns,&#xa;      item,&#xa;      date_dim&#xa; where sr_item_sk = i_item_sk&#xa; and   d_date    in&#xa;&#x9;(select d_date&#xa;&#x9;from date_dim&#xa;&#x9;where d_month_seq in&#xa;&#x9;&#x9;(select d_month_seq&#xa;&#x9;&#x9;from date_dim&#xa;&#x9;  where d_date in (&apos;2002-02-11&apos;,&apos;2002-04-23&apos;,&apos;2002-09-22&apos;,&apos;2002-10-09&apos;)))&#xa; and   sr_returned_date_sk   = d_date_sk&#xa; and i_category IN (&apos;Children&apos;, &apos;Electronics&apos;)&#xa; and i_manager_id BETWEEN 80 and 89&#xa; and sr_return_amt / sr_return_quantity between 226 and 255&#xa; and sr_reason_sk in (17, 20, 22, 65, 73)&#xa;group by i_item_id),&#xa; cr_items as&#xa; (select i_item_id item_id,&#xa;        sum(cr_return_quantity) cr_item_qty&#xa; from catalog_returns,&#xa;      item,&#xa;      date_dim&#xa; where cr_item_sk = i_item_sk&#xa; and   d_date    in&#xa;&#x9;(select d_date&#xa;&#x9;from date_dim&#xa;  where d_month_seq in&#xa;&#x9;&#x9;(select d_month_seq&#xa;&#x9;&#x9;from date_dim&#xa;&#x9;  &#x9;  where d_date in (&apos;2002-02-11&apos;,&apos;2002-04-23&apos;,&apos;2002-09-22&apos;,&apos;2002-10-09&apos;)))&#xa; and   cr_returned_date_sk   = d_date_sk&#xa; and i_category IN (&apos;Children&apos;, &apos;Electronics&apos;)&#xa; and i_manager_id BETWEEN 80 and 89&#xa; and cr_return_amount / cr_return_quantity between 226 and 255&#xa; and cr_reason_sk in (17, 20, 22, 65, 73)&#xa; group by i_item_id),&#xa; wr_items as&#xa; (select i_item_id item_id,&#xa;        sum(wr_return_quantity) wr_item_qty&#xa; from web_returns,&#xa;      item,&#xa;      date_dim&#xa; where wr_item_sk = i_item_sk&#xa; and   d_date    in&#xa;&#x9;(select d_date&#xa;&#x9;from date_dim&#xa;  where d_month_seq in&#xa;&#x9;&#x9;(select d_month_seq&#xa;&#x9;&#x9;from date_dim&#xa;&#x9;&#x9;&#x9;  where d_date in (&apos;2002-02-11&apos;,&apos;2002-04-23&apos;,&apos;2002-09-22&apos;,&apos;2002-10-09&apos;)))&#xa; and   wr_returned_date_sk   = d_date_sk&#xa; and i_category IN (&apos;Children&apos;, &apos;Electronics&apos;)&#xa; and i_manager_id BETWEEN 80 and 89&#xa; and wr_return_amt / wr_return_quantity between 226 and 255&#xa; and wr_reason_sk in (17, 20, 22, 65, 73)&#xa; group by i_item_id)&#xa;  select top 100 sr_items.item_id&#xa;       ,sr_item_qty&#xa;       ,sr_item_qty/(sr_item_qty+cr_item_qty+wr_item_qty)/3.0 * 100 sr_dev&#xa;       ,cr_item_qty&#xa;       ,cr_item_qty/(sr_item_qty+cr_item_qty+wr_item_qty)/3.0 * 100 cr_dev&#xa;       ,wr_item_qty&#xa;       ,wr_item_qty/(sr_item_qty+cr_item_qty+wr_item_qty)/3.0 * 100 wr_dev&#xa;       ,(sr_item_qty+cr_item_qty+wr_item_qty)/3.0 average&#xa; from sr_items&#xa;     ,cr_items&#xa;     ,wr_items&#xa; where sr_items.item_id=cr_items.item_id&#xa;   and sr_items.item_id=wr_items.item_id&#xa; order by sr_items.item_id&#xa;         ,sr_item_qty" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="68.1975" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE49AFC45CEE0BF99" QueryPlanHash="0x9172587F96B89E29" 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="720" CompileTime="122" CompileCPU="122" CompileMemory="16600"><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:31:51.36" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_7B5B524B]" Table="[store_returns]" 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: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:35:26.06" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_01142BA1]" Table="[catalog_returns]" 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: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: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: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: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:33:11.64" ModificationCount="0" SamplingPercent="73.9601" Statistics="[_WA_Sys_00000003_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-03T15:58:02.35" ModificationCount="0" SamplingPercent="26.7354" Statistics="[_WA_Sys_00000002_76969D2E]" Table="[item]" 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: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.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: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-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:25.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:57.68" ModificationCount="0" SamplingPercent="74.0341" Statistics="[_WA_Sys_00000004_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-09" AvgRowSize="87" EstimatedTotalSubtreeCost="68.1975" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1021]"><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="[Expr1032]"><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="[Expr1033]"><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="[Expr1034]"><Identifier><ColumnReference Column="Expr1034"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="[Expr1035]"><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1036"></ColumnReference><ScalarOperator ScalarString="[Expr1036]"><Identifier><ColumnReference Column="Expr1036"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-09" AvgRowSize="87" EstimatedTotalSubtreeCost="68.1975" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="87" EstimatedTotalSubtreeCost="68.1975" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(numeric(10,0),[Expr1010]/([Expr1010]+[Expr1021]+[Expr1032]),0)/(3.0)*(100.)"><Arithmetic Operation="MULT"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(3.0)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(100.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(numeric(10,0),[Expr1021]/([Expr1010]+[Expr1021]+[Expr1032]),0)/(3.0)*(100.)"><Arithmetic Operation="MULT"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(3.0)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(100.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(numeric(10,0),[Expr1032]/([Expr1010]+[Expr1021]+[Expr1032]),0)/(3.0)*(100.)"><Arithmetic Operation="MULT"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(3.0)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(100.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1036"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(numeric(10,0),[Expr1010]+[Expr1021]+[Expr1032],0)/(3.0)"><Arithmetic Operation="DIV"><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(3.0)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.00563063" EstimateCPU="0.000150059" AvgRowSize="39" EstimatedTotalSubtreeCost="68.1975" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177832" AvgRowSize="39" EstimatedTotalSubtreeCost="68.1917" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1032"></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_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id]=[DSB_SF100].[dbo].[item].[i_item_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00181353" AvgRowSize="27" EstimatedTotalSubtreeCost="23.2326" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1082"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id]=[DSB_SF100].[dbo].[item].[i_item_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="17.0331" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="9.40887" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1128]=(0) THEN NULL ELSE [Expr1129] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1128"></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="Expr1129"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="17.0331" EstimateIO="0" EstimateCPU="0.00183385" AvgRowSize="23" EstimatedTotalSubtreeCost="9.40887" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1128"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_returns].[wr_return_quantity])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1129"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_returns].[wr_return_quantity])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id] = [DSB_SF100].[dbo].[item].[i_item_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="29.2564" EstimateIO="0" EstimateCPU="0.00191705" AvgRowSize="23" EstimatedTotalSubtreeCost="9.40704" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1090"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]=[DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00195826" AvgRowSize="10" EstimatedTotalSubtreeCost="0.179611" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date] = [DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00185348" AvgRowSize="10" EstimatedTotalSubtreeCost="0.177652" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1066"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]=[DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.99367" EstimateIO="0" EstimateCPU="0.00178103" AvgRowSize="11" EstimatedTotalSubtreeCost="0.146742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq] = [DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.99367" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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_month_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="9" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq] IS NOT NULL AND ([DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-02-11&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-04-23&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-09-22&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-10-09&apos;)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-02-11&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-04-23&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-22&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-10-09&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date] IS NOT NULL AND [DSB_SF100].[dbo].[date_dim].[d_month_seq] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></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="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="23960.2" EstimateIO="0" EstimateCPU="0.00196593" AvgRowSize="26" EstimatedTotalSubtreeCost="9.22549" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1091"></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="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" 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_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="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="17" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="23925" EstimateIO="0" EstimateCPU="0.00273883" AvgRowSize="27" EstimatedTotalSubtreeCost="9.19453" 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_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1092"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="18" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="359622" EstimateIO="0" EstimateCPU="0.0882691" AvgRowSize="19" EstimatedTotalSubtreeCost="8.96762" 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_return_quantity"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="19" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="359622" 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_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_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_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]" 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_reason_sk]=(17) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(20) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(22) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(65) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk]=(73))"><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><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="(17)"></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="(20)"></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="(22)"></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="(65)"></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="(73)"></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;=(226.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;=(255.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="(226.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="(255.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="12227.3" EstimatedRowsRead="203145" EstimateIO="0.200768" EstimateCPU="0.0223617" AvgRowSize="54" EstimatedTotalSubtreeCost="0.22313" 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_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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_item_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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;Children&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(80) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(89)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Children&apos;"></Const></ScalarOperator></Compare></ScalarOperator><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></Logical></ScalarOperator><ScalarOperator><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="(80)"></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="(89)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="22" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23.8912" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="13.8219" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1130]=(0) THEN NULL ELSE [Expr1131] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1130"></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="Expr1131"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="23.8912" EstimateIO="0" EstimateCPU="0.0017803" AvgRowSize="23" EstimatedTotalSubtreeCost="13.8219" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1130"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1131"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id] = [DSB_SF100].[dbo].[item].[i_item_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="24" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="44.3097" EstimateIO="0" EstimateCPU="0.00189563" AvgRowSize="23" EstimatedTotalSubtreeCost="13.8201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1095"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]=[DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="25" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00195826" AvgRowSize="10" EstimatedTotalSubtreeCost="0.179611" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date] = [DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00185348" AvgRowSize="10" EstimatedTotalSubtreeCost="0.177652" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1046"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]=[DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="27" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.99367" EstimateIO="0" EstimateCPU="0.00178103" AvgRowSize="11" EstimatedTotalSubtreeCost="0.146742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq] = [DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.99367" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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_month_seq"></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_month_seq] IS NOT NULL AND ([DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-02-11&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-04-23&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-09-22&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-10-09&apos;)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-02-11&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-04-23&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-22&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-10-09&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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_date] IS NOT NULL AND [DSB_SF100].[dbo].[date_dim].[d_month_seq] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></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="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="36078.6" EstimateIO="0" EstimateCPU="0.00194332" AvgRowSize="26" EstimatedTotalSubtreeCost="13.6385" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1096"></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_returns]" Column="cr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" 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_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="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></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_date] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="36188.2" EstimateIO="0" EstimateCPU="0.00295532" AvgRowSize="27" EstimatedTotalSubtreeCost="13.6076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1098"></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_returns]" Column="cr_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="34" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="12227.3" EstimatedRowsRead="203145" EstimateIO="0.200768" EstimateCPU="0.0223617" AvgRowSize="54" EstimatedTotalSubtreeCost="0.22313" 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_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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_item_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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;Children&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(80) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(89)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Children&apos;"></Const></ScalarOperator></Compare></ScalarOperator><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></Logical></ScalarOperator><ScalarOperator><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="(80)"></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="(89)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="35" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="553851" EstimateIO="0" EstimateCPU="0.00103675" AvgRowSize="19" EstimatedTotalSubtreeCost="13.349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference><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_return_quantity"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="553851" 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_returned_date_sk"></ColumnReference><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_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"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></DefinedValue><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_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]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_returns].[cr_returned_date_sk] IS NOT NULL AND ([DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(17) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(20) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(22) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(65) OR [DSB_SF100].[dbo].[catalog_returns].[cr_reason_sk]=(73))"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_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="[catalog_returns]" Column="cr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(17)"></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="(20)"></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="(22)"></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="(65)"></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="(73)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_returns].[cr_return_amount]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity],0)&gt;=(226.0000000000000) AND [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[catalog_returns].[cr_return_quantity],0)&lt;=(255.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(226.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(255.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="37" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="73.1329" EstimateIO="0" EstimateCPU="0" AvgRowSize="31" EstimatedTotalSubtreeCost="44.9572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1132]=(0) THEN NULL ELSE [Expr1133] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1132"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1133"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="73.1329" EstimateIO="0" EstimateCPU="0.00177973" AvgRowSize="31" EstimatedTotalSubtreeCost="44.9572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1132"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[store_returns].[sr_return_quantity])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[store_returns].[sr_return_quantity])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_id] = [DSB_SF100].[dbo].[item].[i_item_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="39" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="141.443" EstimateIO="0" EstimateCPU="0.00189519" AvgRowSize="31" EstimatedTotalSubtreeCost="44.9555" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1109"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]=[DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="40" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00195826" AvgRowSize="10" EstimatedTotalSubtreeCost="0.179611" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date] = [DSB_SF100].[dbo].[date_dim].[d_date]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="121.44" EstimateIO="0" EstimateCPU="0.00185348" AvgRowSize="10" EstimatedTotalSubtreeCost="0.177652" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1110"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]=[DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="42" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.99367" EstimateIO="0" EstimateCPU="0.00178103" AvgRowSize="11" EstimatedTotalSubtreeCost="0.146742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq] = [DSB_SF100].[dbo].[date_dim].[d_month_seq]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="43" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.99367" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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_month_seq"></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_month_seq] IS NOT NULL AND ([DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-02-11&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-04-23&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-09-22&apos; OR [DSB_SF100].[dbo].[date_dim].[d_date]=&apos;2002-10-09&apos;)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-02-11&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-04-23&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-22&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-10-09&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="44" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></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_date] IS NOT NULL AND [DSB_SF100].[dbo].[date_dim].[d_month_seq] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></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="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="45" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="115681" EstimateIO="0" EstimateCPU="0.00194286" AvgRowSize="34" EstimatedTotalSubtreeCost="44.7739" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1111"></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_returns]" Column="sr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="46" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" 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_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="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></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_date] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="47" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="116706" EstimateIO="0" EstimateCPU="0.0021443" AvgRowSize="35" EstimatedTotalSubtreeCost="44.743" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1112"></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="49" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="12227.3" EstimatedRowsRead="203145" EstimateIO="0.160357" EstimateCPU="0.0223617" AvgRowSize="43" EstimatedTotalSubtreeCost="0.182718" 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_item_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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_item_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></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;Children&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(80) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(89)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Children&apos;"></Const></ScalarOperator></Compare></ScalarOperator><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></Logical></ScalarOperator><ScalarOperator><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="(80)"></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="(89)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="50" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.8139e+06" EstimateIO="0" EstimateCPU="0.000865148" AvgRowSize="19" EstimatedTotalSubtreeCost="44.55" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><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_return_quantity"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="51" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.8139e+06" EstimatedRowsRead="7.22732e+07" EstimateIO="36.5991" EstimateCPU="7.95007" AvgRowSize="28" EstimatedTotalSubtreeCost="44.5491" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><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_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_returned_date_sk"></ColumnReference></DefinedValue><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_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]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_returned_date_sk] IS NOT NULL AND ([DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(17) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(20) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(22) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(65) OR [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]=(73))"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_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="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(17)"></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="(20)"></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="(22)"></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="(65)"></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="(73)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&gt;=(226.0000000000000) AND [DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&lt;=(255.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_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="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(226.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_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="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(255.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></TopSort></RelOp></ComputeScalar></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
