<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 inv as&#xa;(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy&#xa;       ,stdev,mean, case mean when 0 then null else stdev/mean end cov&#xa; from(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy&#xa;            ,stdev(inv_quantity_on_hand) stdev,avg(inv_quantity_on_hand) mean&#xa;      from inventory&#xa;          ,item&#xa;          ,warehouse&#xa;          ,date_dim&#xa;      where inv_item_sk = i_item_sk&#xa;        and inv_warehouse_sk = w_warehouse_sk&#xa;        and inv_date_sk = d_date_sk&#xa;        and d_year =2001&#xa;        and i_category IN (&apos;Sports&apos;, &apos;Women&apos;)&#xa;        and i_manager_id BETWEEN 81 and 100&#xa;        and inv_quantity_on_hand between 800 and 1000&#xa;      group by w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy) foo&#xa; where case mean when 0 then 0 else stdev/mean end &gt; 1)&#xa;select inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean, inv1.cov&#xa;        ,inv2.w_warehouse_sk,inv2.i_item_sk,inv2.d_moy,inv2.mean, inv2.cov&#xa;from inv inv1,inv inv2&#xa;where inv1.i_item_sk = inv2.i_item_sk&#xa;  and inv1.w_warehouse_sk =  inv2.w_warehouse_sk&#xa;  and inv1.d_moy=2&#xa;  and inv2.d_moy=2+1&#xa;order by inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean,inv1.cov&#xa;        ,inv2.d_moy,inv2.mean, inv2.cov" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="477.4" StatementEstRows="43799.9" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xCF1E9A248CDD2E16" QueryPlanHash="0x9DD86A1DD433344D" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelForPDWCompilation" CachedPlanSize="560" CompileTime="55" CompileCPU="55" CompileMemory="4464"><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:34:07.14" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.46" ModificationCount="0" SamplingPercent="26.7458" Statistics="[_WA_Sys_00000015_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.27" ModificationCount="0" SamplingPercent="73.9589" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:09.47" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_71D1E811]" Table="[warehouse]" 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:34:09.29" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:03.99" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_00200768]" Table="[inventory]" 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:11.59" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:03.23" ModificationCount="0" SamplingPercent="73.921" Statistics="[_WA_Sys_00000009_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:11.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="43799.9" EstimateIO="0" EstimateCPU="0.000437999" AvgRowSize="56" EstimatedTotalSubtreeCost="477.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_moy]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_moy]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="[Expr1020]"><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1021]"><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="43799.9" EstimateIO="0" EstimateCPU="0.000437999" AvgRowSize="56" EstimatedTotalSubtreeCost="477.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="43799.9" EstimateIO="0.00563063" EstimateCPU="0.465118" AvgRowSize="56" EstimatedTotalSubtreeCost="477.399" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1009"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1010"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1020"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1021"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="43799.9" EstimateIO="0" EstimateCPU="0.000437999" AvgRowSize="56" EstimatedTotalSubtreeCost="476.929" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1009]=(0) THEN NULL ELSE [Expr1008]/CONVERT_IMPLICIT(float(53),[Expr1009],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1020]=(0) THEN NULL ELSE [Expr1019]/CONVERT_IMPLICIT(float(53),[Expr1020],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="43799.9" EstimateIO="0" EstimateCPU="0.243722" AvgRowSize="56" EstimatedTotalSubtreeCost="476.928" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1063"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[item].[i_item_sk] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]=[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="65525.1" EstimateIO="0" EstimateCPU="0.246374" AvgRowSize="31" EstimatedTotalSubtreeCost="238.357" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="218417" EstimateIO="0" EstimateCPU="0.00218417" AvgRowSize="31" EstimatedTotalSubtreeCost="238.111" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="sqrt(CASE WHEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END IS NULL THEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END ELSE CASE WHEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END&gt;(0.0000000000000000e+000) THEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END ELSE (0.0000000000000000e+000) END END)"><Intrinsic FunctionName="sqrt"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1029]=(0) THEN NULL ELSE [globalagg1031]/CONVERT_IMPLICIT(int,[globalagg1029],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1029"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="218417" EstimateIO="0" EstimateCPU="1.71909" AvgRowSize="55" EstimatedTotalSubtreeCost="238.109" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="globalagg1023"></ColumnReference><ColumnReference Column="globalagg1025"></ColumnReference><ColumnReference Column="globalagg1027"></ColumnReference><ColumnReference Column="globalagg1029"></ColumnReference><ColumnReference Column="globalagg1031"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1023"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1022])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1022"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1025"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1024])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1024"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1027"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1026])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1029"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1028])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1028"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1031"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1030])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="436454" EstimateIO="0" EstimateCPU="0" AvgRowSize="76" EstimatedTotalSubtreeCost="236.39" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1022"></ColumnReference><ColumnReference Column="partialagg1024"></ColumnReference><ColumnReference Column="partialagg1026"></ColumnReference><ColumnReference Column="partialagg1028"></ColumnReference><ColumnReference Column="partialagg1030"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1028"></ColumnReference><ScalarOperator ScalarString="[partialagg1022]"><Identifier><ColumnReference Column="partialagg1022"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="436454" EstimateIO="0" EstimateCPU="3.74796" AvgRowSize="76" EstimatedTotalSubtreeCost="236.39" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1022"></ColumnReference><ColumnReference Column="partialagg1024"></ColumnReference><ColumnReference Column="partialagg1026"></ColumnReference><ColumnReference Column="partialagg1030"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1022"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1024"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1053])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1026"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1054])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1030"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="0.0222069" AvgRowSize="59" EstimatedTotalSubtreeCost="232.642" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0)"><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054"></ColumnReference><ScalarOperator ScalarString="square(CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0))"><Intrinsic FunctionName="square"><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="1.18787" AvgRowSize="43" EstimatedTotalSubtreeCost="232.62" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="1.44931" AvgRowSize="23" EstimatedTotalSubtreeCost="231.429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1055"></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="[inventory]" Column="inv_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="101.428" EstimatedRowsRead="73064" EstimateIO="0.0274894" EstimateCPU="0.00805274" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0355422" 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_moy"></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_moy"></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_moy]=(2) AND [DSB_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.58388e+06" EstimateIO="0" EstimateCPU="2.35022" AvgRowSize="23" EstimatedTotalSubtreeCost="229.893" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1056"></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="[inventory]" Column="inv_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14548" EstimatedRowsRead="203145" EstimateIO="0.0942286" EstimateCPU="0.0223617" AvgRowSize="25" EstimatedTotalSubtreeCost="0.11659" 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_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_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;Sports&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Women&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(81) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><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;Sports&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;Women&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="(81)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.41561e+07" EstimatedRowsRead="3.98818e+08" EstimateIO="165.888" EstimateCPU="43.8699" AvgRowSize="23" EstimatedTotalSubtreeCost="209.758" TableCardinality="3.98818e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&gt;=(800) AND [DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&lt;=(1000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(800)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1009]=(0) THEN (0.0000000000000000e+000) ELSE [Expr1008]/CONVERT_IMPLICIT(float(53),[Expr1009],0) END&gt;(1.0000000000000000e+000)"><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="22" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="65525.8" EstimateIO="0" EstimateCPU="0.246377" AvgRowSize="31" EstimatedTotalSubtreeCost="238.327" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="218419" EstimateIO="0" EstimateCPU="0.00218419" AvgRowSize="31" EstimatedTotalSubtreeCost="238.08" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="sqrt(CASE WHEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END IS NULL THEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END ELSE CASE WHEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END&gt;(0.0000000000000000e+000) THEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END ELSE (0.0000000000000000e+000) END END)"><Intrinsic FunctionName="sqrt"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1039]=(0) THEN NULL ELSE [globalagg1041]/CONVERT_IMPLICIT(int,[globalagg1039],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1039"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1041"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1039"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="218419" EstimateIO="0" EstimateCPU="1.60186" AvgRowSize="55" EstimatedTotalSubtreeCost="238.078" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="globalagg1033"></ColumnReference><ColumnReference Column="globalagg1035"></ColumnReference><ColumnReference Column="globalagg1037"></ColumnReference><ColumnReference Column="globalagg1039"></ColumnReference><ColumnReference Column="globalagg1041"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1033"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1032])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1035"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1034])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1037"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1039"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1038])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1041"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1040])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="26" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="436565" EstimateIO="0" EstimateCPU="0" AvgRowSize="70" EstimatedTotalSubtreeCost="236.476" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1032"></ColumnReference><ColumnReference Column="partialagg1034"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1038"></ColumnReference><ScalarOperator ScalarString="[partialagg1032]"><Identifier><ColumnReference Column="partialagg1032"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="436565" EstimateIO="0" EstimateCPU="3.70047" AvgRowSize="70" EstimatedTotalSubtreeCost="236.476" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1032"></ColumnReference><ColumnReference Column="partialagg1034"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1032"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1034"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1043])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1036"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1044])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1040"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="0.0232429" AvgRowSize="53" EstimatedTotalSubtreeCost="232.776" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0)"><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="square(CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0))"><Intrinsic FunctionName="square"><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="1.24321" AvgRowSize="37" EstimatedTotalSubtreeCost="232.753" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="30" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="25" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="1.45725" AvgRowSize="23" EstimatedTotalSubtreeCost="231.506" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1045"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="32" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="106.159" EstimatedRowsRead="73064" EstimateIO="0.0274894" EstimateCPU="0.00805274" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0355422" 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_moy"></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_moy"></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_moy]=(3) AND [DSB_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.58388e+06" EstimateIO="0" EstimateCPU="2.35022" AvgRowSize="23" EstimatedTotalSubtreeCost="229.963" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></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="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14548" EstimatedRowsRead="203145" EstimateIO="0.16403" EstimateCPU="0.0223617" AvgRowSize="44" EstimatedTotalSubtreeCost="0.186392" 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_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_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;Sports&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Women&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(81) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><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;Sports&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;Women&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="(81)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.41561e+07" EstimatedRowsRead="3.98818e+08" EstimateIO="165.888" EstimateCPU="43.8699" AvgRowSize="23" EstimatedTotalSubtreeCost="209.758" TableCardinality="3.98818e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&gt;=(800) AND [DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&lt;=(1000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(800)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1020]=(0) THEN (0.0000000000000000e+000) ELSE [Expr1019]/CONVERT_IMPLICIT(float(53),[Expr1020],0) END&gt;(1.0000000000000000e+000)"><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple><StmtSimple StatementText="&#xa;;&#xa;with inv as&#xa;(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy&#xa;       ,stdev,mean, case mean when 0 then null else stdev/mean end cov&#xa; from(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy&#xa;            ,stdev(inv_quantity_on_hand) stdev,avg(inv_quantity_on_hand) mean&#xa;      from inventory&#xa;          ,item&#xa;          ,warehouse&#xa;          ,date_dim&#xa;      where inv_item_sk = i_item_sk&#xa;        and inv_warehouse_sk = w_warehouse_sk&#xa;        and inv_date_sk = d_date_sk&#xa;        and d_year =2001&#xa;        and i_category IN (&apos;Sports&apos;, &apos;Women&apos;)&#xa;        and i_manager_id BETWEEN 81 and 100&#xa;        and inv_quantity_on_hand between 800 and 1000&#xa;      group by w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy) foo&#xa; where case mean when 0 then 0 else stdev/mean end &gt; 1)&#xa;select inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean, inv1.cov&#xa;        ,inv2.w_warehouse_sk,inv2.i_item_sk,inv2.d_moy,inv2.mean, inv2.cov&#xa;from inv inv1,inv inv2&#xa;where inv1.i_item_sk = inv2.i_item_sk&#xa;  and inv1.w_warehouse_sk =  inv2.w_warehouse_sk&#xa;  and inv1.d_moy=2&#xa;  and inv2.d_moy=2+1&#xa;  and inv1.cov &gt; 1.5&#xa;order by inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean,inv1.cov&#xa;        ,inv2.d_moy,inv2.mean, inv2.cov" StatementId="2" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="477.373" StatementEstRows="23990.2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x286280FBFE803378" QueryPlanHash="0x9DD86A1DD433344D" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelForPDWCompilation" CachedPlanSize="560" CompileTime="54" CompileCPU="54" CompileMemory="4480"><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:34:07.14" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.46" ModificationCount="0" SamplingPercent="26.7458" Statistics="[_WA_Sys_00000015_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.27" ModificationCount="0" SamplingPercent="73.9589" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:09.47" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_71D1E811]" Table="[warehouse]" 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:34:09.29" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:03.99" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_00200768]" Table="[inventory]" 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:11.59" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_00200768]" Table="[inventory]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:03.23" ModificationCount="0" SamplingPercent="73.921" Statistics="[_WA_Sys_00000009_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:11.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23990.2" EstimateIO="0" EstimateCPU="0.000239902" AvgRowSize="56" EstimatedTotalSubtreeCost="477.373" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_moy]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_moy]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="[Expr1020]"><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1021]"><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="23990.2" EstimateIO="0" EstimateCPU="0.000239902" AvgRowSize="56" EstimatedTotalSubtreeCost="477.373" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="23990.2" EstimateIO="0.00563063" EstimateCPU="0.240479" AvgRowSize="56" EstimatedTotalSubtreeCost="477.373" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1009"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1010"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1020"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1021"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23990.2" EstimateIO="0" EstimateCPU="0.000239902" AvgRowSize="56" EstimatedTotalSubtreeCost="477.127" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1009]=(0) THEN NULL ELSE [Expr1008]/CONVERT_IMPLICIT(float(53),[Expr1009],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1020]=(0) THEN NULL ELSE [Expr1019]/CONVERT_IMPLICIT(float(53),[Expr1020],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="23990.2" EstimateIO="0" EstimateCPU="0.153664" AvgRowSize="56" EstimatedTotalSubtreeCost="477.126" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1063"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_item_sk]=[DSB_SF100].[dbo].[item].[i_item_sk] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]=[DSB_SF100].[dbo].[warehouse].[w_warehouse_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="35889.6" EstimateIO="0" EstimateCPU="0.534685" AvgRowSize="31" EstimatedTotalSubtreeCost="238.646" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="218417" EstimateIO="0" EstimateCPU="0.00218417" AvgRowSize="31" EstimatedTotalSubtreeCost="238.111" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="sqrt(CASE WHEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END IS NULL THEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END ELSE CASE WHEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END&gt;(0.0000000000000000e+000) THEN CASE WHEN ([globalagg1023]-(1))&gt;(0) THEN ([globalagg1027]-square([globalagg1025])/CONVERT_IMPLICIT(float(53),[globalagg1023],0))/CONVERT_IMPLICIT(float(53),[globalagg1023]-(1),0) ELSE NULL END ELSE (0.0000000000000000e+000) END END)"><Intrinsic FunctionName="sqrt"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1029]=(0) THEN NULL ELSE [globalagg1031]/CONVERT_IMPLICIT(int,[globalagg1029],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1029"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="218417" EstimateIO="0" EstimateCPU="1.71909" AvgRowSize="55" EstimatedTotalSubtreeCost="238.109" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="globalagg1023"></ColumnReference><ColumnReference Column="globalagg1025"></ColumnReference><ColumnReference Column="globalagg1027"></ColumnReference><ColumnReference Column="globalagg1029"></ColumnReference><ColumnReference Column="globalagg1031"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1023"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1022])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1022"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1025"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1024])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1024"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1027"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1026])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1029"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1028])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1028"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1031"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1030])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="436454" EstimateIO="0" EstimateCPU="0" AvgRowSize="76" EstimatedTotalSubtreeCost="236.39" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1022"></ColumnReference><ColumnReference Column="partialagg1024"></ColumnReference><ColumnReference Column="partialagg1026"></ColumnReference><ColumnReference Column="partialagg1028"></ColumnReference><ColumnReference Column="partialagg1030"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1028"></ColumnReference><ScalarOperator ScalarString="[partialagg1022]"><Identifier><ColumnReference Column="partialagg1022"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="436454" EstimateIO="0" EstimateCPU="3.74796" AvgRowSize="76" EstimatedTotalSubtreeCost="236.39" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1022"></ColumnReference><ColumnReference Column="partialagg1024"></ColumnReference><ColumnReference Column="partialagg1026"></ColumnReference><ColumnReference Column="partialagg1030"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1022"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1024"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1053])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1026"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1054])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1030"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="0.0222069" AvgRowSize="59" EstimatedTotalSubtreeCost="232.642" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0)"><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054"></ColumnReference><ScalarOperator ScalarString="square(CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0))"><Intrinsic FunctionName="square"><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="1.18787" AvgRowSize="43" EstimatedTotalSubtreeCost="232.62" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.22069e+06" EstimateIO="0" EstimateCPU="1.44931" AvgRowSize="23" EstimatedTotalSubtreeCost="231.429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1055"></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="[inventory]" Column="inv_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="101.428" EstimatedRowsRead="73064" EstimateIO="0.0274894" EstimateCPU="0.00805274" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0355422" 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_moy"></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_moy"></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_moy]=(2) AND [DSB_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.58388e+06" EstimateIO="0" EstimateCPU="2.35022" AvgRowSize="23" EstimatedTotalSubtreeCost="229.893" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1056"></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="[inventory]" Column="inv_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14548" EstimatedRowsRead="203145" EstimateIO="0.0942286" EstimateCPU="0.0223617" AvgRowSize="25" EstimatedTotalSubtreeCost="0.11659" 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_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_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;Sports&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Women&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(81) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><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;Sports&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;Women&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="(81)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.41561e+07" EstimatedRowsRead="3.98818e+08" EstimateIO="165.888" EstimateCPU="43.8699" AvgRowSize="23" EstimatedTotalSubtreeCost="209.758" TableCardinality="3.98818e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&gt;=(800) AND [DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&lt;=(1000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(800)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1009]=(0) THEN NULL ELSE [Expr1008]/CONVERT_IMPLICIT(float(53),[Expr1009],0) END&gt;(1.5000000000000000e+000) AND CASE WHEN [Expr1009]=(0) THEN (0.0000000000000000e+000) ELSE [Expr1008]/CONVERT_IMPLICIT(float(53),[Expr1009],0) END&gt;(1.0000000000000000e+000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1.5000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="22" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="65525.8" EstimateIO="0" EstimateCPU="0.246377" AvgRowSize="31" EstimatedTotalSubtreeCost="238.327" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="218419" EstimateIO="0" EstimateCPU="0.00218419" AvgRowSize="31" EstimatedTotalSubtreeCost="238.08" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="sqrt(CASE WHEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END IS NULL THEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END ELSE CASE WHEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END&gt;(0.0000000000000000e+000) THEN CASE WHEN ([globalagg1033]-(1))&gt;(0) THEN ([globalagg1037]-square([globalagg1035])/CONVERT_IMPLICIT(float(53),[globalagg1033],0))/CONVERT_IMPLICIT(float(53),[globalagg1033]-(1),0) ELSE NULL END ELSE (0.0000000000000000e+000) END END)"><Intrinsic FunctionName="sqrt"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Intrinsic FunctionName="square"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1039]=(0) THEN NULL ELSE [globalagg1041]/CONVERT_IMPLICIT(int,[globalagg1039],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1039"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="globalagg1041"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1039"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="218419" EstimateIO="0" EstimateCPU="1.60186" AvgRowSize="55" EstimatedTotalSubtreeCost="238.078" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="globalagg1033"></ColumnReference><ColumnReference Column="globalagg1035"></ColumnReference><ColumnReference Column="globalagg1037"></ColumnReference><ColumnReference Column="globalagg1039"></ColumnReference><ColumnReference Column="globalagg1041"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1033"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1032])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1035"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1034])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1037"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1039"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1038])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1041"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1040])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="26" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="436565" EstimateIO="0" EstimateCPU="0" AvgRowSize="70" EstimatedTotalSubtreeCost="236.476" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1032"></ColumnReference><ColumnReference Column="partialagg1034"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1038"></ColumnReference><ScalarOperator ScalarString="[partialagg1032]"><Identifier><ColumnReference Column="partialagg1032"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="436565" EstimateIO="0" EstimateCPU="3.70047" AvgRowSize="70" EstimatedTotalSubtreeCost="236.476" 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="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="partialagg1032"></ColumnReference><ColumnReference Column="partialagg1034"></ColumnReference><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1032"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1034"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1043])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1036"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1044])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1040"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ScalarOperator ScalarString="ANY([DSB_SF100].[dbo].[date_dim].[d_moy])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[warehouse].[w_warehouse_name] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_name] AND [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] = [DSB_SF100].[dbo].[warehouse].[w_warehouse_sk] AND [DSB_SF100].[dbo].[item].[i_item_sk] = [DSB_SF100].[dbo].[item].[i_item_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="0.0232429" AvgRowSize="53" EstimatedTotalSubtreeCost="232.776" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0)"><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="square(CONVERT_IMPLICIT(float(53),[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand],0))"><Intrinsic FunctionName="square"><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="1.24321" AvgRowSize="37" EstimatedTotalSubtreeCost="232.753" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="30" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="25" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.32429e+06" EstimateIO="0" EstimateCPU="1.45725" AvgRowSize="23" EstimatedTotalSubtreeCost="231.506" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1045"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="32" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="106.159" EstimatedRowsRead="73064" EstimateIO="0.0274894" EstimateCPU="0.00805274" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0355422" 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_moy"></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_moy"></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_moy]=(3) AND [DSB_SF100].[dbo].[date_dim].[d_year]=(2001)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.58388e+06" EstimateIO="0" EstimateCPU="2.35022" AvgRowSize="23" EstimatedTotalSubtreeCost="229.963" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></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="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14548" EstimatedRowsRead="203145" EstimateIO="0.16403" EstimateCPU="0.0223617" AvgRowSize="44" EstimatedTotalSubtreeCost="0.186392" 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_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_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;Sports&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Women&apos;) AND [DSB_SF100].[dbo].[item].[i_manager_id]&gt;=(81) AND [DSB_SF100].[dbo].[item].[i_manager_id]&lt;=(100)"><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;Sports&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;Women&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="(81)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_manager_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.41561e+07" EstimatedRowsRead="3.98818e+08" EstimateIO="165.888" EstimateCPU="43.8699" AvgRowSize="23" EstimatedTotalSubtreeCost="209.758" TableCardinality="3.98818e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&gt;=(800) AND [DSB_SF100].[dbo].[inventory].[inv_quantity_on_hand]&lt;=(1000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(800)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[inventory]" Column="inv_quantity_on_hand"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1020]=(0) THEN (0.0000000000000000e+000) ELSE [Expr1019]/CONVERT_IMPLICIT(float(53),[Expr1020],0) END&gt;(1.0000000000000000e+000)"><Compare CompareOp="GT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0.0000000000000000e+000)"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="float" Precision="53" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000000000e+000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
