<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 my_customers as (&#xa; select distinct c_customer_sk&#xa;        , c_current_addr_sk&#xa; from&#xa;        ( select cs_sold_date_sk sold_date_sk,&#xa;                 cs_bill_customer_sk customer_sk,&#xa;                 cs_item_sk item_sk,&#xa;                 cs_wholesale_cost wholesale_cost&#xa;          from   catalog_sales&#xa;          union all&#xa;          select ws_sold_date_sk sold_date_sk,&#xa;                 ws_bill_customer_sk customer_sk,&#xa;                 ws_item_sk item_sk,&#xa;                 ws_wholesale_cost wholesale_cost&#xa;          from   web_sales&#xa;         ) cs_or_ws_sales,&#xa;         item,&#xa;         date_dim,&#xa;         customer&#xa; where   sold_date_sk = d_date_sk&#xa;         and item_sk = i_item_sk&#xa;         and i_category = &apos;Books&apos;&#xa;         and i_class = &apos;entertainments&apos;&#xa;         and c_customer_sk = cs_or_ws_sales.customer_sk&#xa;         and d_moy = 5&#xa;         and d_year = 2002&#xa;         and wholesale_cost BETWEEN 70 AND 100&#xa;         and c_birth_year BETWEEN 1973 AND 1986&#xa; )&#xa; , my_revenue as (&#xa; select c_customer_sk,&#xa;        sum(ss_ext_sales_price) as revenue&#xa; from   my_customers,&#xa;        store_sales,&#xa;        customer_address,&#xa;        store,&#xa;        date_dim&#xa; where  c_current_addr_sk = ca_address_sk&#xa;        and ca_county = s_county&#xa;        and ca_state = s_state&#xa;        and ss_sold_date_sk = d_date_sk&#xa;        and c_customer_sk = ss_customer_sk&#xa;        and ss_wholesale_cost BETWEEN 70 AND 100&#xa;        and s_state in (&apos;IA&apos;,&apos;IN&apos;,&apos;KS&apos;&#xa;                    ,&apos;KY&apos;,&apos;MI&apos;,&apos;MS&apos;&#xa;                    ,&apos;OH&apos;,&apos;PA&apos;,&apos;TX&apos;&#xa;                    ,&apos;WI&apos;)&#xa;        and d_month_seq between (select distinct d_month_seq+1&#xa;                                 from   date_dim where d_year = 2002 and d_moy = 5)&#xa;                           and  (select distinct d_month_seq+3&#xa;                                 from   date_dim where d_year = 2002 and d_moy = 5)&#xa; group by c_customer_sk&#xa; )&#xa; , segments as&#xa; (select cast((revenue/50) as int) as segment&#xa;  from   my_revenue&#xa; )&#xa;  select top 100 segment, count(*) as num_customers, segment*50 as segment_base&#xa; from segments&#xa; group by segment&#xa; order by segment, num_customers" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="281.867" StatementEstRows="4.31916" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x04F4C2F72D49B65F" QueryPlanHash="0x3CB49F616335A840" 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="568" CompileTime="217" CompileCPU="217" CompileMemory="20104"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T18:33:48.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:08.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:07.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.83" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:47.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000014_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:45.64" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:02.87" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_03F0984C]" Table="[catalog_sales]" 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:32:01.09" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:10.82" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:52.49" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_6EF57B66]" Table="[customer_address]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:18.10" ModificationCount="0" SamplingPercent="27.048" Statistics="[_WA_Sys_0000000B_76969D2E]" Table="[item]" 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:32:02.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:05.89" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:06.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:46.67" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000014_03F0984C]" Table="[catalog_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-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:32:06.56" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:57.68" ModificationCount="0" SamplingPercent="74.0341" Statistics="[_WA_Sys_00000004_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000019_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:23.70" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000018_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:49.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000005_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><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></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.31916" EstimateIO="0" EstimateCPU="1.29575e-08" AvgRowSize="19" EstimatedTotalSubtreeCost="281.867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="[Expr1029]"><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="[Expr1030]"><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="[Expr1031]"><Identifier><ColumnReference Column="Expr1031"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="4.31916" EstimateIO="0" EstimateCPU="1.29575e-08" AvgRowSize="19" EstimatedTotalSubtreeCost="281.867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.31916" EstimateIO="0" EstimateCPU="4.31916e-08" AvgRowSize="19" EstimatedTotalSubtreeCost="281.867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="[Expr1029]*(50)"><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="4.31916" EstimateIO="0.00563063" EstimateCPU="0.000152156" AvgRowSize="15" EstimatedTotalSubtreeCost="281.867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1029"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.31916" EstimateIO="0" EstimateCPU="0" AvgRowSize="15" EstimatedTotalSubtreeCost="281.861" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1220],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1220"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="4.31916" EstimateIO="0" EstimateCPU="0.00178437" AvgRowSize="15" EstimatedTotalSubtreeCost="281.861" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1220"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1220"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1029"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1029] = [Expr1029]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.31917" EstimateIO="0" EstimateCPU="4.31917e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="281.859" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CONVERT(int,[Expr1028]/(50.),0)"><Convert DataType="int" Style="0" Implicit="0"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50.)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.31917" EstimateIO="0" EstimateCPU="0" AvgRowSize="24" EstimatedTotalSubtreeCost="281.859" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1218]=(0) THEN NULL ELSE [Expr1219] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1218"></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="Expr1219"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="4.31917" EstimateIO="0" EstimateCPU="0.00178988" AvgRowSize="24" EstimatedTotalSubtreeCost="281.859" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1218"></ColumnReference><ColumnReference Column="Expr1219"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1218"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1219"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="18.649" EstimateIO="0" EstimateCPU="0.00180936" AvgRowSize="16" EstimatedTotalSubtreeCost="281.857" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1043"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1044"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]&lt;=[Expr1035] AND [Expr1043]=[Expr1044]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0896025" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="2.48e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0896022" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1035"></ColumnReference></OutputList><Assert StartupExpression="0"><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177617" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0895998" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1027])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="109.52" EstimateIO="0" EstimateCPU="0.00201227" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0878236" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1027"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1027"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1027] = [Expr1027]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="111.289" EstimateIO="0" EstimateCPU="1.11289e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0858113" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1027"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]+(3)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="111.289" 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_month_seq"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2002) AND [DSB_SF100].[dbo].[date_dim].[d_moy]=(5)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2002)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1034]&gt;(1) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="62.1634" EstimateIO="0" EstimateCPU="6.21634e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="281.766" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="62.1634" EstimateIO="0" EstimateCPU="0.00188683" AvgRowSize="20" EstimatedTotalSubtreeCost="281.766" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1043"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1044"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]&gt;=[Expr1033] AND [Expr1043]=[Expr1044]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0896025" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="20" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="2.48e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0896022" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1033"></ColumnReference></OutputList><Assert StartupExpression="0"><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177617" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0895998" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1024])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="109.52" EstimateIO="0" EstimateCPU="0.00201227" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0878236" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1024"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1024"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1024] = [Expr1024]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="111.289" EstimateIO="0" EstimateCPU="1.11289e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0858113" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="111.289" 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_month_seq"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_year]=(2002) AND [DSB_SF100].[dbo].[date_dim].[d_moy]=(5)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2002)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1032]&gt;(1) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></ComputeScalar></RelOp><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="207.211" EstimateIO="0" EstimateCPU="2.07211e-06" AvgRowSize="24" EstimatedTotalSubtreeCost="281.674" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="207.211" EstimateIO="0" EstimateCPU="0.00334012" AvgRowSize="20" EstimatedTotalSubtreeCost="281.674" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1206"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="27" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1478.66" EstimateIO="0" EstimateCPU="0.00330788" AvgRowSize="11" EstimatedTotalSubtreeCost="0.707577" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_address_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1207"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_county"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_county"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_address].[ca_county]=[DSB_SF100].[dbo].[store].[s_county] AND [DSB_SF100].[dbo].[customer_address].[ca_state]=[DSB_SF100].[dbo].[store].[s_state]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_county"></ColumnReference></Identifier></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><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="131.342" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="28" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_county"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_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="[store]" Column="s_county"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[store].[s_state]=&apos;IA&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;IN&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;KS&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;KY&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;MI&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;MS&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;OH&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;PA&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;TX&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;WI&apos;) AND [DSB_SF100].[dbo].[store].[s_county] IS NOT NULL AND [DSB_SF100].[dbo].[store].[s_county] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IN&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;KS&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;KY&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;MI&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;MS&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;OH&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;PA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_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="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;WI&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_county"></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="[store]" Column="s_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="768933" EstimatedRowsRead="1.00092e+06" EstimateIO="0.58162" EstimateCPU="0.110117" AvgRowSize="32" EstimatedTotalSubtreeCost="0.691737" 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_county"></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_county"></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]&gt;=&apos;IA&apos; AND [DSB_SF100].[dbo].[customer_address].[ca_state]&lt;=&apos;WI&apos; AND [DSB_SF100].[dbo].[customer_address].[ca_county] IS NOT NULL AND [DSB_SF100].[dbo].[customer_address].[ca_state]&gt;=&apos;IA&apos; AND [DSB_SF100].[dbo].[customer_address].[ca_state]&lt;=&apos;WI&apos; AND [DSB_SF100].[dbo].[customer_address].[ca_county] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><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><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><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><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_address]" Column="ca_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="120367" EstimateIO="0" EstimateCPU="0.00220918" AvgRowSize="24" EstimatedTotalSubtreeCost="280.963" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1208"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="121579" EstimateIO="0" EstimateCPU="0.00195798" AvgRowSize="24" EstimatedTotalSubtreeCost="280.931" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1048"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_customer_sk]=[DSB_SF100].[dbo].[store_sales].[ss_customer_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2577.7" EstimateIO="0" EstimateCPU="0.00178891" AvgRowSize="15" EstimatedTotalSubtreeCost="118.709" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_customer_sk] = [DSB_SF100].[dbo].[customer].[c_customer_sk] AND [DSB_SF100].[dbo].[customer].[c_current_addr_sk] = [DSB_SF100].[dbo].[customer].[c_current_addr_sk]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="35" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="3006.78" EstimateIO="0" EstimateCPU="0.00355979" AvgRowSize="15" EstimatedTotalSubtreeCost="118.707" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1066"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1006"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1006]=[DSB_SF100].[dbo].[item].[i_item_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="36" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="675891" EstimateIO="0" EstimateCPU="0.00312438" AvgRowSize="19" EstimatedTotalSubtreeCost="118.568" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1071"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1004"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Union1004]=[DSB_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="37" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="111.289" 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></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_moy]=(5) AND [DSB_SF100].[dbo].[date_dim].[d_year]=(2002)"><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="(5)"></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="(2002)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.31598e+07" EstimateIO="0" EstimateCPU="0.00691584" AvgRowSize="23" EstimatedTotalSubtreeCost="118.479" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1072"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Union1005"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_customer_sk]=[Union1005]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1005"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="458733" EstimatedRowsRead="1.99897e+06" EstimateIO="0.689241" EstimateCPU="0.219902" AvgRowSize="19" EstimatedTotalSubtreeCost="0.909143" TableCardinality="1.99897e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_year]&gt;=(1973) AND [DSB_SF100].[dbo].[customer].[c_birth_year]&lt;=(1986) AND [DSB_SF100].[dbo].[customer].[c_current_addr_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1973)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1986)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_addr_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="40" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="5.75684e+07" EstimateIO="0" EstimateCPU="7.02739e-05" AvgRowSize="19" EstimatedTotalSubtreeCost="117.562" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Column="Union1006"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.86814e+07" EstimatedRowsRead="1.44208e+08" EstimateIO="62.5926" EstimateCPU="15.8629" AvgRowSize="24" EstimatedTotalSubtreeCost="78.4555" TableCardinality="1.44208e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_bill_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_wholesale_cost]&gt;=(70.00) AND [DSB_SF100].[dbo].[catalog_sales].[cs_wholesale_cost]&lt;=(100.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(70.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="42" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.88869e+07" EstimatedRowsRead="7.1845e+07" EstimateIO="31.1851" EstimateCPU="7.90296" AvgRowSize="24" EstimatedTotalSubtreeCost="39.0881" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_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_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_bill_customer_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_wholesale_cost]&gt;=(70.00) AND [DSB_SF100].[dbo].[web_sales].[ws_wholesale_cost]&lt;=(100.00)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(70.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Concat></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="44" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="907.465" EstimatedRowsRead="203145" EstimateIO="0.112597" EstimateCPU="0.0223617" AvgRowSize="30" EstimatedTotalSubtreeCost="0.134959" 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_class"></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_class"></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]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[item].[i_category]=&apos;Books&apos; AND [DSB_SF100].[dbo].[item].[i_class]=&apos;entertainments&apos; AND [DSB_SF100].[dbo].[item].[i_category]=&apos;Books&apos; AND [DSB_SF100].[dbo].[item].[i_class]=&apos;entertainments&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Books&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;entertainments&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Books&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_class"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;entertainments&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="9.10706e+07" EstimatedRowsRead="2.88583e+08" EstimateIO="130.474" EstimateCPU="31.7442" AvgRowSize="25" EstimatedTotalSubtreeCost="162.219" TableCardinality="2.88583e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(70.00) AND [DSB_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(100.00) AND [DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_sales].[ss_customer_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(70.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_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="[store_sales]" Column="ss_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="46" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="73064" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_month_seq] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_month_seq"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></ComputeScalar></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
