<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;TOP 100&#xa;  COUNT(DISTINCT ws_order_number) AS [order count],&#xa;  SUM(ws_ext_ship_cost) AS [total shipping cost],&#xa;  SUM(ws_net_profit) AS [total net profit]&#xa;FROM web_sales AS ws1, date_dim, customer_address, web_site&#xa;WHERE&#xa;  d_date BETWEEN &apos;2002-3-01&apos; AND (&#xa;    DATEADD(DAY, 60, CAST(&apos;2002-3-01&apos; AS DATE))&#xa;  )&#xa;  AND ws1.ws_ship_date_sk = d_date_sk&#xa;  AND ws1.ws_ship_addr_sk = ca_address_sk&#xa;  AND ca_state = &apos;TX&apos;&#xa;  AND ws1.ws_web_site_sk = web_site_sk&#xa;  AND web_company_name = &apos;pri&apos;&#xa;  AND EXISTS(&#xa;    SELECT&#xa;      *&#xa;    FROM web_sales AS ws2&#xa;    WHERE&#xa;      ws1.ws_order_number = ws2.ws_order_number&#xa;      AND ws1.ws_warehouse_sk &lt;&gt; ws2.ws_warehouse_sk&#xa;  )&#xa;  AND NOT EXISTS(&#xa;    SELECT&#xa;      *&#xa;    FROM web_returns AS wr1&#xa;    WHERE&#xa;      ws1.ws_order_number = wr1.wr_order_number&#xa;  )&#xa;ORDER BY&#xa;  COUNT(DISTINCT ws_order_number)" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="112.681" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF4AE28EC870445AE" QueryPlanHash="0xF6F848925589596E" 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="512" CompileTime="248" CompileCPU="247" CompileMemory="15336"><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-03T15:24:43.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000001D_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.21" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:40.44" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:39.22" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:29.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.43" ModificationCount="0" SamplingPercent="73.9837" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:44.75" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000022_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.84" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000F_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.45" ModificationCount="0" SamplingPercent="73.9544" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.70" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:41.07" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:39.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:41.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="45" EstimatedTotalSubtreeCost="112.681" 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="112.681" 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="112.681" 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="112.681" 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,[Expr1946],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1946"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1947]=(0) THEN NULL ELSE [Expr1948] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1947"></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="Expr1948"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1949]=(0) THEN NULL ELSE [Expr1950] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1949"></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="Expr1950"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00417994" AvgRowSize="45" EstimatedTotalSubtreeCost="112.681" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1946"></ColumnReference><ColumnReference Column="Expr1947"></ColumnReference><ColumnReference Column="Expr1948"></ColumnReference><ColumnReference Column="Expr1949"></ColumnReference><ColumnReference Column="Expr1950"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1946"></ColumnReference><ScalarOperator ScalarString="COUNT(DISTINCT [TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws1].[ws_order_number])"><Aggregate Distinct="1" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1947"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_sales].[ws_ext_ship_cost] as [ws1].[ws_ext_ship_cost])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1948"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_sales].[ws_ext_ship_cost] as [ws1].[ws_ext_ship_cost])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1949"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_sales].[ws_net_profit] as [ws1].[ws_net_profit])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1950"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_sales].[ws_net_profit] as [ws1].[ws_net_profit])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="6" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="302.485" EstimateIO="0.023125" EstimateCPU="0.000635218" AvgRowSize="21" EstimatedTotalSubtreeCost="112.676" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Left Anti Semi Join" EstimateRows="302.485" EstimateIO="0" EstimateCPU="0.0274788" AvgRowSize="21" EstimatedTotalSubtreeCost="112.643" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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_Bitmap1932"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_order_number"></ColumnReference></HashKeysProbe><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Left Semi Join" EstimateRows="16661.7" EstimateIO="0" EstimateCPU="0.0622665" AvgRowSize="21" EstimatedTotalSubtreeCost="110.39" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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_Bitmap1875"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws1].[ws_order_number]=[TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number] AND [TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws1].[ws_warehouse_sk]&lt;&gt;[TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="9" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="16661.7" EstimateIO="18.7054" EstimateCPU="0.0175158" AvgRowSize="25" EstimatedTotalSubtreeCost="81.1364" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></DistributionKey><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="16661.7" EstimateIO="0" EstimateCPU="0.197469" AvgRowSize="25" EstimatedTotalSubtreeCost="53.5557" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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_Bitmap1711"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="193577" EstimateIO="0" EstimateCPU="0.0830261" AvgRowSize="29" EstimatedTotalSubtreeCost="52.7263" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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_Bitmap1544"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="24" EstimateIO="0.003125" EstimateCPU="1.834e-05" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00314334" TableCardinality="24" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_company_name"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_company_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_site].[web_company_name]=&apos;pri&apos; AND [TPCDS_SF100].[dbo].[web_site].[web_company_name]=&apos;pri&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_company_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;pri&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_company_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;pri&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.32292e+06" EstimateIO="0" EstimateCPU="0.152557" AvgRowSize="33" EstimatedTotalSubtreeCost="52.6401" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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_Bitmap1233"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_ship_date_sk] as [ws1].[ws_ship_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="63.5593" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_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" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-03-01&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-04-30&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-03-01&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-04-30&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18917e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="48.1297" EstimateCPU="3.95592" AvgRowSize="37" EstimatedTotalSubtreeCost="52.0856" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ship_addr_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_ext_ship_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws1]" Column="ws_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" Alias="[ws1]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_ship_date_sk] as [ws1].[ws_ship_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_ship_addr_sk] as [ws1].[ws_ship_addr_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_web_site_sk] as [ws1].[ws_web_site_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws1].[ws_warehouse_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_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="[TPCDS_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="[TPCDS_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="[TPCDS_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></Hash></RelOp><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="79281.6" EstimatedRowsRead="1.00002e+06" EstimateIO="0.309827" EstimateCPU="0.110018" AvgRowSize="17" EstimatedTotalSubtreeCost="0.419845" TableCardinality="1.00002e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[customer_address].[ca_state]=&apos;TX&apos; AND [TPCDS_SF100].[dbo].[customer_address].[ca_state]=&apos;TX&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;TX&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="142087" EstimateIO="0" EstimateCPU="0.289205" AvgRowSize="15" EstimatedTotalSubtreeCost="29.1911" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] = [TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] AND [TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number] = [TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="20" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="178953" EstimateIO="3.22984" EstimateCPU="0.259156" AvgRowSize="15" EstimatedTotalSubtreeCost="28.9019" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></DistributionKey><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="178953" EstimateIO="0" EstimateCPU="0.353992" AvgRowSize="15" EstimatedTotalSubtreeCost="23.8582" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] = [TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] AND [TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number] = [TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="203661" EstimatedRowsRead="7.19256e+07" EstimateIO="19.5134" EstimateCPU="3.95592" AvgRowSize="15" EstimatedTotalSubtreeCost="23.4694" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_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="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" Alias="[ws2]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] as [ws2].[ws_warehouse_sk] IS NOT NULL AND PROBE([Opt_Bitmap1875],[TPCDS_SF100].[dbo].[web_sales].[ws_order_number] as [ws2].[ws_order_number])"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_warehouse_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Opt_Bitmap1875"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Alias="[ws2]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.19569e+06" EstimatedRowsRead="7.19569e+06" EstimateIO="1.43382" EstimateCPU="0.791542" AvgRowSize="11" EstimatedTotalSubtreeCost="2.22536" TableCardinality="7.19569e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_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" IsImplicitBroadcast="1"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Alias="[wr1]" Column="wr_order_number"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" Alias="[wr1]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></Top></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
