<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="&#xa;select top 100&#xa;   count(distinct ws_order_number) as &quot;order count&quot;&#xa;  ,sum(ws_ext_ship_cost) as &quot;total shipping cost&quot;&#xa;  ,sum(ws_net_profit) as &quot;total net profit&quot;&#xa;from&#xa;   web_sales ws1&#xa;  ,date_dim&#xa;  ,customer_address&#xa;  ,web_site&#xa;where&#xa;    d_date between &apos;2002-6-01&apos; and&#xa;           dateadd(day, 60, cast(&apos;2002-6-01&apos; as date))&#xa;and ws1.ws_ship_date_sk = d_date_sk&#xa;and ws1.ws_ship_addr_sk = ca_address_sk&#xa;and ca_state in (&apos;AR&apos;,&apos;GA&apos;,&apos;IL&apos;&#xa;            ,&apos;SD&apos; ,&apos;TX&apos; ,&apos;WI&apos;)&#xa;and ws1.ws_web_site_sk = web_site_sk&#xa;and web_gmt_offset &gt;= -5&#xa;and ws1.ws_list_price between 226 and 255&#xa;and exists (select *&#xa;            from web_sales ws2&#xa;            where ws1.ws_order_number = ws2.ws_order_number&#xa;              and ws1.ws_warehouse_sk &lt;&gt; ws2.ws_warehouse_sk)&#xa;and not exists(select *&#xa;               from web_returns wr1&#xa;               where ws1.ws_order_number = wr1.wr_order_number&#xa;               and wr1.wr_reason_sk in (3, 6, 18, 30, 40)&#xa;               )&#xa;order by count(distinct ws_order_number)" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="100.187" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE681DCC054588A02" QueryPlanHash="0xAEA9FFE5136F6023" 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="328" CompileTime="76" CompileCPU="76" CompileMemory="8568"><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:35:52.93" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:11.64" ModificationCount="0" SamplingPercent="73.9601" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:55.27" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000001D_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:38.36" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:38.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000022_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.23" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:54.43" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000019_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:13.96" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000015_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:52.78" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:56.57" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:53.67" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:20.59" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:54.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:20.41" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="45" EstimatedTotalSubtreeCost="100.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="[Expr1011]"><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[Expr1012]"><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[Expr1013]"><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="45" EstimatedTotalSubtreeCost="100.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="45" EstimatedTotalSubtreeCost="100.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(100)"><Const ConstValue="(100)"></Const></ScalarOperator></TopExpression><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="100.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1099],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1099"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1100]=(0) THEN NULL ELSE [Expr1101] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1100"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1101"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1102]=(0) THEN NULL ELSE [Expr1103] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1102"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1103"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00189365" AvgRowSize="45" EstimatedTotalSubtreeCost="100.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1099"></ColumnReference><ColumnReference Column="Expr1100"></ColumnReference><ColumnReference Column="Expr1101"></ColumnReference><ColumnReference Column="Expr1102"></ColumnReference><ColumnReference Column="Expr1103"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1099"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1100"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1014])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1014"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1101"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1014])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1014"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1102"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1015])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1103"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1015])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="11857.1" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="100.185" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Column="partialagg1014"></ColumnReference><ColumnReference Column="partialagg1015"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1014"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1095]=(0) THEN NULL ELSE [Expr1096] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1095"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1096"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1097]=(0) THEN NULL ELSE [Expr1098] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1097"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1098"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="11857.1" EstimateIO="0" EstimateCPU="0.0265031" AvgRowSize="45" EstimatedTotalSubtreeCost="100.185" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Column="Expr1095"></ColumnReference><ColumnReference Column="Expr1096"></ColumnReference><ColumnReference Column="Expr1097"></ColumnReference><ColumnReference Column="Expr1098"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1095"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_sales].[ws_ext_ship_cost] as [ws1].[ws_ext_ship_cost])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1096"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_sales].[ws_ext_ship_cost] as [ws1].[ws_ext_ship_cost])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1097"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_sales].[ws_net_profit] as [ws1].[ws_net_profit])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1098"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_sales].[ws_net_profit] as [ws1].[ws_net_profit])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></HashKeysBuild><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Left Anti Semi Join" EstimateRows="11918.1" EstimateIO="0" EstimateCPU="0.0305659" AvgRowSize="21" EstimatedTotalSubtreeCost="100.158" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1083"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_order_number"></ColumnReference></HashKeysProbe><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Left Semi Join" EstimateRows="16093.5" EstimateIO="0" EstimateCPU="0.159165" AvgRowSize="21" EstimatedTotalSubtreeCost="94.5566" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1092"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_order_number] as [ws1].[ws_order_number]=[DSB_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number] AND [DSB_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws1].[ws_warehouse_sk]&lt;&gt;[DSB_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="16093.5" EstimateIO="0" EstimateCPU="0.0109666" AvgRowSize="25" EstimatedTotalSubtreeCost="66.9333" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1089"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="65.5918" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-06-01&apos; AND [DSB_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-07-31&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-06-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-07-31&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="552214" EstimateIO="0" EstimateCPU="0.122259" AvgRowSize="29" EstimatedTotalSubtreeCost="66.8431" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1091"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.76118e+06" EstimateIO="0" EstimateCPU="0.0491691" AvgRowSize="33" EstimatedTotalSubtreeCost="66.1377" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1070"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_web_site_sk] as [ws1].[ws_web_site_sk]=[DSB_SF100].[dbo].[web_site].[web_site_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14" EstimatedRowsRead="24" EstimateIO="0.003125" EstimateCPU="1.834e-05" AvgRowSize="16" EstimatedTotalSubtreeCost="0.00314334" TableCardinality="24" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_site].[web_gmt_offset]&gt;=(-5.)"><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_gmt_offset"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-5.)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.01916e+06" EstimatedRowsRead="7.1845e+07" EstimateIO="54.5721" EstimateCPU="7.90296" AvgRowSize="42" EstimatedTotalSubtreeCost="62.4751" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" Alias="[ws1]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_list_price] as [ws1].[ws_list_price]&gt;=(226.00) AND [DSB_SF100].[dbo].[web_sales].[ws_list_price] as [ws1].[ws_list_price]&lt;=(255.00) AND [DSB_SF100].[dbo].[web_sales].[ws_ship_date_sk] as [ws1].[ws_ship_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_sales].[ws_ship_addr_sk] as [ws1].[ws_ship_addr_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_sales].[ws_web_site_sk] as [ws1].[ws_web_site_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws1].[ws_warehouse_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(226.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(255.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="226755" EstimatedRowsRead="1.00092e+06" EstimateIO="0.310103" EstimateCPU="0.110117" AvgRowSize="17" EstimatedTotalSubtreeCost="0.42022" TableCardinality="1.00092e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;AR&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;GA&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;IL&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;SD&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;TX&apos; OR [DSB_SF100].[dbo].[customer_address].[ca_state]=&apos;WI&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;AR&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;GA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IL&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;SD&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;TX&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;WI&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18274e+07" EstimatedRowsRead="7.1845e+07" EstimateIO="19.4916" EstimateCPU="7.90296" AvgRowSize="15" EstimatedTotalSubtreeCost="27.3945" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" Alias="[ws2]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="19" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.68817e+06" EstimatedRowsRead="1.44021e+07" EstimateIO="3.9092" EstimateCPU="1.58425" AvgRowSize="15" EstimatedTotalSubtreeCost="5.49345" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_order_number"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_order_number"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" Alias="[wr1]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_returns].[wr_reason_sk] as [wr1].[wr_reason_sk]=(3) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] as [wr1].[wr_reason_sk]=(6) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] as [wr1].[wr_reason_sk]=(18) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] as [wr1].[wr_reason_sk]=(30) OR [DSB_SF100].[dbo].[web_returns].[wr_reason_sk] as [wr1].[wr_reason_sk]=(40)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(18)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(40)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Top></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
