<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;  *&#xa;FROM (&#xa;  SELECT&#xa;    COUNT(*) AS h8_30_to_9&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 8&#xa;    AND time_dim.t_minute &gt;= 30&#xa;    AND (&#xa;      (&#xa;        household_demographics.hd_dep_count = -1&#xa;        AND household_demographics.hd_vehicle_count &lt;= -1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 1&#xa;        AND household_demographics.hd_vehicle_count &lt;= 1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 3&#xa;        AND household_demographics.hd_vehicle_count &lt;= 3 + 2&#xa;      )&#xa;    )&#xa;    AND store.s_store_name = &apos;ese&apos;&#xa;) AS s1, (&#xa;  SELECT&#xa;    COUNT(*) AS h9_to_9_30&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 9&#xa;    AND time_dim.t_minute &lt; 30&#xa;    AND (&#xa;      (&#xa;        household_demographics.hd_dep_count = -1&#xa;        AND household_demographics.hd_vehicle_count &lt;= -1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 1&#xa;        AND household_demographics.hd_vehicle_count &lt;= 1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 3&#xa;        AND household_demographics.hd_vehicle_count &lt;= 3 + 2&#xa;      )&#xa;    )&#xa;    AND store.s_store_name = &apos;ese&apos;&#xa;) AS s2, (&#xa;  SELECT&#xa;    COUNT(*) AS h9_30_to_10&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 9&#xa;    AND time_dim.t_minute &gt;= 30&#xa;    AND (&#xa;      (&#xa;        household_demographics.hd_dep_count = -1&#xa;        AND household_demographics.hd_vehicle_count &lt;= -1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 1&#xa;        AND household_demographics.hd_vehicle_count &lt;= 1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 3&#xa;        AND household_demographics.hd_vehicle_count &lt;= 3 + 2&#xa;      )&#xa;    )&#xa;    AND store.s_store_name = &apos;ese&apos;&#xa;) AS s3, (&#xa;  SELECT&#xa;    COUNT(*) AS h10_to_10_30&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 10&#xa;    AND time_dim.t_minute &lt; 30&#xa;    AND (&#xa;      (&#xa;        household_demographics.hd_dep_count = -1&#xa;        AND household_demographics.hd_vehicle_count &lt;= -1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 1&#xa;        AND household_demographics.hd_vehicle_count &lt;= 1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 3&#xa;        AND household_demographics.hd_vehicle_count &lt;= 3 + 2&#xa;      )&#xa;    )&#xa;    AND store.s_store_name = &apos;ese&apos;&#xa;) AS s4, (&#xa;  SELECT&#xa;    COUNT(*) AS h10_30_to_11&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 10&#xa;    AND time_dim.t_minute &gt;= 30&#xa;    AND (&#xa;      (&#xa;        household_demographics.hd_dep_count = -1&#xa;        AND household_demographics.hd_vehicle_count &lt;= -1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 1&#xa;        AND household_demographics.hd_vehicle_count &lt;= 1 + 2&#xa;      )&#xa;      OR (&#xa;        household_demographics.hd_dep_count = 3&#xa;        AND household_demographics.hd_vehicle_count &lt;= 3 + 2&#xa;      )&#xa;    )&#xa;    AND store.s_store_name = &apos;ese&apos;&#xa;) AS s5, (&#xa;  SELECT&#xa;    COUNT(*) AS h11_to_11_30&#xa;  FROM store_sales, household_demographics, time_dim, store&#xa;  WHERE&#xa;    ss_sold_time_sk = time_dim.t_time_sk&#xa;    AND ss_hdemo_sk = household_demographics.hd_demo_sk&#xa;    AND ss_store_sk = s_store_sk&#xa;    AND time_dim.t_hour = 11&#xa;    AND time_dim" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="935.951" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4DDF0A503C9D06E3" QueryPlanHash="0x6BC0454AB1B27C63" 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="1576" CompileTime="470" CompileCPU="469" CompileMemory="28392"><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:42:22.76" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_07C12930]" Table="[store]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:33.00" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000006_07C12930]" Table="[store]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:20.40" ModificationCount="0" SamplingPercent="97.762" Statistics="[_WA_Sys_00000004_7C4F7684]" Table="[household_demographics]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:17.58" ModificationCount="0" SamplingPercent="69.1852" Statistics="[_WA_Sys_00000005_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:54.12" ModificationCount="0" SamplingPercent="97.7675" Statistics="[_WA_Sys_00000005_7C4F7684]" Table="[household_demographics]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:17.36" ModificationCount="0" SamplingPercent="69.2087" Statistics="[_WA_Sys_00000004_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:16.93" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:12.21" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000006_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:14.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:11.14" ModificationCount="0" SamplingPercent="69.1757" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:28.99" ModificationCount="0" SamplingPercent="97.7648" Statistics="[_WA_Sys_00000001_7C4F7684]" Table="[household_demographics]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4e-09" AvgRowSize="39" EstimatedTotalSubtreeCost="935.951" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="[Expr1017]"><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="[Expr1026]"><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="[Expr1035]"><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="[Expr1044]"><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="[Expr1053]"><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1062"></ColumnReference><ScalarOperator ScalarString="[Expr1062]"><Identifier><ColumnReference Column="Expr1062"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="[Expr1071]"><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="4e-09" AvgRowSize="39" EstimatedTotalSubtreeCost="935.951" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="ManyToOne"><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177647" AvgRowSize="39" EstimatedTotalSubtreeCost="935.951" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1053"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1079],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1079"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1079"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1079"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1078])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1078"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="8" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1078"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00499091" AvgRowSize="15" EstimatedTotalSubtreeCost="116.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1078"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1078"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="643151" EstimateIO="0" EstimateCPU="0.203132" AvgRowSize="9" EstimatedTotalSubtreeCost="116.949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1627"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2551.1" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(11) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&lt;(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1635"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1626"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="39" EstimatedTotalSubtreeCost="818.961" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177647" AvgRowSize="35" EstimatedTotalSubtreeCost="818.961" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1075],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1075"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1075"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1075"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1074])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1074"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="25" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1074"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00502302" AvgRowSize="15" EstimatedTotalSubtreeCost="116.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1074"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1074"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="27" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="649574" EstimateIO="0" EstimateCPU="0.203649" AvgRowSize="9" EstimatedTotalSubtreeCost="116.949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1855"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2576.57" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(12) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&lt;(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="29" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1863"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="30" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1854"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="34" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="8" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="35" EstimatedTotalSubtreeCost="701.97" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="37" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177647" AvgRowSize="31" EstimatedTotalSubtreeCost="701.97" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="38" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="40" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1073],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1073"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.989" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1073"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1073"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1072])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1072"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="42" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1072"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="43" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00501791" AvgRowSize="15" EstimatedTotalSubtreeCost="116.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1072"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1072"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="648550" EstimateIO="0" EstimateCPU="0.203566" AvgRowSize="9" EstimatedTotalSubtreeCost="116.949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1969"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2572.52" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(8) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&gt;=(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="46" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1977"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="47" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="48" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="49" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1968"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="51" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="18" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="52" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="53" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="31" EstimatedTotalSubtreeCost="584.979" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="54" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017764" AvgRowSize="27" EstimatedTotalSubtreeCost="584.979" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="55" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="27" EstimatedTotalSubtreeCost="467.991" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="56" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017763" AvgRowSize="23" EstimatedTotalSubtreeCost="467.991" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="57" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="23" EstimatedTotalSubtreeCost="351" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="58" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177621" AvgRowSize="19" EstimatedTotalSubtreeCost="351" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="59" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="19" EstimatedTotalSubtreeCost="234.01" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="60" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177612" AvgRowSize="15" EstimatedTotalSubtreeCost="234.01" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1088"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1089"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1088]=[Expr1089]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="61" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="15" EstimatedTotalSubtreeCost="117.02" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1088"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1088"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="63" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="11" EstimatedTotalSubtreeCost="117.02" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1035"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1083],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1083"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="64" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="1" EstimateIO="0.023125" EstimateCPU="2.1e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="117.02" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="globalagg1083"></ColumnReference></OutputList><Move DistributionType="Any" MoveTopology="OneToMany"><RelOp NodeId="65" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1083"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1083"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1082])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1082"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="66" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.985" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1082"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="67" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00489546" AvgRowSize="15" EstimatedTotalSubtreeCost="116.952" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1082"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1082"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="68" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="624062" EstimateIO="0" EstimateCPU="0.201596" AvgRowSize="9" EstimatedTotalSubtreeCost="116.947" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1399"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="69" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2475.38" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(10) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&lt;(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="70" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1407"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="71" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="72" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="73" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1398"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="75" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="76" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Move></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="77" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="79" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1026"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1085],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1085"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="80" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1085"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1085"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1084])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1084"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="81" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1084"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="82" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00498317" AvgRowSize="15" EstimatedTotalSubtreeCost="116.953" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1084"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1084"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="83" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="641604" EstimateIO="0" EstimateCPU="0.203007" AvgRowSize="9" EstimatedTotalSubtreeCost="116.948" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap2083"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="84" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2544.96" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(9) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&gt;=(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="85" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap2091"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="86" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="87" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="88" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap2082"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="90" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="91" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="92" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="94" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1062"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1062"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1077],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1077"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="95" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1077"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1077"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1076])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1076"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="96" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1076"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="97" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00498584" AvgRowSize="15" EstimatedTotalSubtreeCost="116.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1076"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1076"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="98" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="642138" EstimateIO="0" EstimateCPU="0.20305" AvgRowSize="9" EstimatedTotalSubtreeCost="116.949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1741"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="99" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2547.08" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(11) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&gt;=(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="100" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1749"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="101" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="102" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="103" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1740"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="105" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="106" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="7" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="107" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="109" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1087],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1087"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="110" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1087"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1087"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1086])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="111" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1086"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="112" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00498823" AvgRowSize="15" EstimatedTotalSubtreeCost="116.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1086"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1086"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="113" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="642616" EstimateIO="0" EstimateCPU="0.203089" AvgRowSize="9" EstimatedTotalSubtreeCost="116.949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1278"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="114" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2548.98" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(9) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&lt;(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="115" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1299"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="116" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="117" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="118" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1267"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="120" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="121" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="122" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1089"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1089"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="124" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1044"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1081],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1081"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="125" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="15" EstimatedTotalSubtreeCost="116.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1081"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1081"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1080])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="126" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="116.985" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1080"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="127" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00489055" AvgRowSize="15" EstimatedTotalSubtreeCost="116.952" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1080"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1080"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="128" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="623079" EstimateIO="0" EstimateCPU="0.201517" AvgRowSize="9" EstimatedTotalSubtreeCost="116.947" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1513"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="129" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2471.48" EstimatedRowsRead="86254" EstimateIO="0.0320216" EstimateCPU="0.00950364" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0415252" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_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="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_hour]=(10) AND [TPCDS_SF100].[dbo].[time_dim].[t_minute]&gt;=(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_hour"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_minute"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="130" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.04641e+07" EstimateIO="0" EstimateCPU="0.312484" AvgRowSize="11" EstimatedTotalSubtreeCost="116.645" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1521"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="131" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1037.17" EstimateIO="0" EstimateCPU="0.0160979" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0217607" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="132" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7193" EstimatedRowsRead="7193" EstimateIO="0.00485581" EstimateCPU="0.00080693" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00566274" TableCardinality="7193" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_demo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></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="[household_demographics]" Column="hd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(-1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(1) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(1) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(3) OR [TPCDS_SF100].[dbo].[household_demographics].[hd_dep_count]=(3) AND [TPCDS_SF100].[dbo].[household_demographics].[hd_vehicle_count]&lt;=(5)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_dep_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[household_demographics]" Column="hd_vehicle_count"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="133" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.26316e+07" EstimateIO="0" EstimateCPU="0.563121" AvgRowSize="15" EstimatedTotalSubtreeCost="116.31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1512"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_store_sk]=[TPCDS_SF100].[dbo].[store].[s_store_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="135" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="55" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_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="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos; AND [TPCDS_SF100].[dbo].[store].[s_store_name]=&apos;ese&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ese&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="136" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.65435e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="98.884" EstimateCPU="15.8277" AvgRowSize="19" EstimatedTotalSubtreeCost="114.712" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_hdemo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_hdemo_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_time_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="[store_sales]" Column="ss_hdemo_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="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
