ÿþ<?xml version="1.0" encoding="utf-16"?> <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.0.2746.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> <BatchSequence> <Batch> <Statements> <StmtSimple StatementCompId="1" StatementEstRows="25" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="10287" StatementText="/* TPC_H Query 5 - Local Supplier Volume */&#xD;&#xA;SELECT N_NAME, SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)) AS REVENUE&#xD;&#xA;FROM CUSTOMER, ORDERS, LINEITEM, SUPPLIER, NATION, REGION&#xD;&#xA;WHERE C_CUSTKEY = O_CUSTKEY AND L_ORDERKEY = O_ORDERKEY AND L_SUPPKEY = S_SUPPKEY AND&#xD;&#xA; C_NATIONKEY = S_NATIONKEY AND S_NATIONKEY = N_NATIONKEY AND N_REGIONKEY = R_REGIONKEY&#xD;&#xA; AND R_NAME = 'ASIA' AND O_ORDERDATE &gt;= '1994-01-01' AND O_ORDERDATE &lt; CONVERT(DATE,DATEADD(YY, 1, '1994-01-01'))&#xD;&#xA;GROUP BY N_NAME ORDER BY REVENUE DESC&#xD;&#xA;" StatementType="SELECT" QueryHash="0x5E7489BB771B438A" QueryPlanHash="0x925497DC2400FB6D"> <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> <QueryPlan CachedPlanSize="176" CompileTime="154" CompileCPU="153" CompileMemory="3160"> <RelOp AvgRowSize="40" EstimateCPU="0.00028115" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="10287"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1020" /> </OutputList> <MemoryFractions Input="0.5" Output="1" /> <Sort Distinct="false"> <OrderBy> <OrderByColumn Ascending="false"> <ColumnReference Column="Expr1020" /> </OrderByColumn> </OrderBy> <RelOp AvgRowSize="40" EstimateCPU="7.25E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Aggregate" NodeId="1" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="10286.9"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1020" /> </OutputList> <StreamAggregate> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1020" /> <ScalarOperator ScalarString="SUM([partialagg1023])"> <Aggregate AggType="SUM" Distinct="false"> <ScalarOperator> <Identifier> <ColumnReference Column="partialagg1023" /> </Identifier> </ScalarOperator> </Aggregate> </ScalarOperator> </DefinedValue> </DefinedValues> <GroupBy> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </GroupBy> <RelOp AvgRowSize="40" EstimateCPU="0.00113648" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Sort" NodeId="2" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="10286.9"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1023" /> </OutputList> <MemoryFractions Input="3.16868E-06" Output="0.5" /> <Sort Distinct="false"> <OrderBy> <OrderByColumn Ascending="true"> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OrderByColumn> </OrderBy> <RelOp AvgRowSize="40" EstimateCPU="0.0285131" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="10286.9"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1023" /> </OutputList> <Parallelism> <RelOp AvgRowSize="40" EstimateCPU="24.617" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Partial Aggregate" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="10286.9"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1023" /> </OutputList> <MemoryFractions Input="0" Output="0" /> <Hash> <DefinedValues> <DefinedValue> <ColumnReference Column="partialagg1023" /> <ScalarOperator ScalarString="SUM([Expr1021])"> <Aggregate AggType="SUM" Distinct="false"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1021" /> </Identifier> </ScalarOperator> </Aggregate> </ScalarOperator> </DefinedValue> </DefinedValues> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </HashKeysBuild> <BuildResidual> <ScalarOperator ScalarString="[tpch].[dbo].[NATION].[N_NAME] = [tpch].[dbo].[NATION].[N_NAME]"> <Compare CompareOp="IS"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </BuildResidual> <RelOp AvgRowSize="40" EstimateCPU="42.5205" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13844600" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="10262.3"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1021" /> </OutputList> <MemoryFractions Input="0.0367132" Output="0.0367131" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </HashKeysProbe> <ProbeResidual> <ScalarOperator ScalarString="[tpch].[dbo].[SUPPLIER].[S_NATIONKEY]=[tpch].[dbo].[NATION].[N_NATIONKEY] AND [tpch].[dbo].[LINEITEM].[L_SUPPKEY]=[tpch].[dbo].[SUPPLIER].[S_SUPPKEY]"> <Logical Operation="AND"> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </Logical> </ScalarOperator> </ProbeResidual> <RelOp AvgRowSize="15" EstimateCPU="0.879938" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000000" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2.16699"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </PartitionColumns> <RelOp AvgRowSize="15" EstimateCPU="0.275039" EstimateIO="1.01201" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000000" LogicalOp="Index Scan" NodeId="7" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.28705" TableCardinality="1000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Index="[S_NATIONKEY_IDX]" IndexKind="NonClustered" /> </IndexScan> </RelOp> </Parallelism> </RelOp> <RelOp AvgRowSize="48" EstimateCPU="23.0441" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13846600" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="10217.6"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1021" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </PartitionColumns> <RelOp AvgRowSize="48" EstimateCPU="105.04" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13846600" LogicalOp="Inner Join" NodeId="9" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="10194.6"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1021" /> </OutputList> <MemoryFractions Input="9.58528E-05" Output="9.58525E-05" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_REGIONKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </HashKeysProbe> <RelOp AvgRowSize="11" EstimateCPU="0.0285019" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317918"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_REGIONKEY" /> </OutputList> <Parallelism PartitioningType="Broadcast"> <RelOp AvgRowSize="36" EstimateCPU="0.0001625" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Scan" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032875" TableCardinality="5"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_REGIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_REGIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[REGION]" Index="[PK_R_REGIONKEY]" IndexKind="Clustered" /> <Predicate> <ScalarOperator ScalarString="[tpch].[dbo].[REGION].[R_NAME]='ASIA'"> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_NAME" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="'ASIA'" /> </ScalarOperator> </Compare> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </Parallelism> </RelOp> <RelOp AvgRowSize="52" EstimateCPU="170.167" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69232800" LogicalOp="Inner Join" NodeId="13" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="10089.5"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <MemoryFractions Input="9.50606E-05" Output="9.50603E-05" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </HashKeysProbe> <RelOp AvgRowSize="40" EstimateCPU="0.028621" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Distribute Streams" NodeId="14" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0319305"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </OutputList> <Parallelism PartitioningType="Broadcast"> <RelOp AvgRowSize="40" EstimateCPU="0.0001845" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Clustered Index Scan" NodeId="15" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0033095" TableCardinality="25"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[NATION]" Index="[PK_N_NATIONKEY]" IndexKind="Clustered" /> </IndexScan> </RelOp> </Parallelism> </RelOp> <RelOp AvgRowSize="23" EstimateCPU="217.472" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="91028400" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="9919.28"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <MemoryFractions Input="0.388652" Output="0.388651" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </HashKeysProbe> <RelOp AvgRowSize="15" EstimateCPU="11.8607" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15000000" LogicalOp="Repartition Streams" NodeId="17" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="256.716"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </PartitionColumns> <RelOp AvgRowSize="15" EstimateCPU="4.12504" EstimateIO="240.731" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15000000" LogicalOp="Clustered Index Scan" NodeId="18" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="244.856" TableCardinality="15000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Index="[PK_C_CUSTKEY]" IndexKind="Clustered" /> </IndexScan> </RelOp> </Parallelism> </RelOp> <RelOp AvgRowSize="23" EstimateCPU="95.3864" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="91028400" LogicalOp="Repartition Streams" NodeId="19" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="9445.1"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </PartitionColumns> <RelOp AvgRowSize="23" EstimateCPU="358.159" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="91028400" LogicalOp="Inner Join" NodeId="20" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="9349.71"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <MemoryFractions Input="0.574444" Output="0.574442" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </HashKeysProbe> <ProbeResidual> <ScalarOperator ScalarString="[tpch].[dbo].[LINEITEM].[L_ORDERKEY]=[tpch].[dbo].[ORDERS].[O_ORDERKEY]"> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </ProbeResidual> <RelOp AvgRowSize="19" EstimateCPU="20.675" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="22755700" LogicalOp="Bitmap Create" NodeId="21" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="301.93"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </OutputList> <Bitmap> <DefinedValues> <DefinedValue> <ColumnReference Column="Opt_Bitmap1022" /> </DefinedValue> </DefinedValues> <HashKeys> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </HashKeys> <RelOp AvgRowSize="19" EstimateCPU="20.675" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="22755700" LogicalOp="Repartition Streams" NodeId="22" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="301.93"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </PartitionColumns> <RelOp AvgRowSize="19" EstimateCPU="6.25785" EstimateIO="274.997" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="22755700" LogicalOp="Clustered Index Seek" NodeId="23" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="281.255" TableCardinality="150000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </OutputList> <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Index="[O_ORDERDATE_CLUIDX]" IndexKind="Clustered" /> <SeekPredicates> <SeekPredicateNew> <SeekKeys> <StartRange ScanType="GE"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1994-01-01'"> <Const ConstValue="'1994-01-01'" /> </ScalarOperator> </RangeExpressions> </StartRange> <EndRange ScanType="LT"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1995-01-01'"> <Const ConstValue="'1995-01-01'" /> </ScalarOperator> </RangeExpressions> </EndRange> </SeekKeys> </SeekPredicateNew> </SeekPredicates> </IndexScan> </RelOp> </Parallelism> </RelOp> </Bitmap> </RelOp> <RelOp AvgRowSize="27" EstimateCPU="106.173" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="91028400" LogicalOp="Repartition Streams" NodeId="24" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="8689.62"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </PartitionColumns> <RelOp AvgRowSize="27" EstimateCPU="15.0009" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="600038000" LogicalOp="Compute Scalar" NodeId="26" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="8511.44"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1021" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1021" /> <ScalarOperator ScalarString="[tpch].[dbo].[LINEITEM].[L_EXTENDEDPRICE]*((1.000000000000000e+000)-[tpch].[dbo].[LINEITEM].[L_DISCOUNT])"> <Arithmetic Operation="MULT"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> </Identifier> </ScalarOperator> <ScalarOperator> <Arithmetic Operation="SUB"> <ScalarOperator> <Const ConstValue="(1.000000000000000e+000)" /> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </Identifier> </ScalarOperator> </Arithmetic> </ScalarOperator> </Arithmetic> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp AvgRowSize="35" EstimateCPU="165.01" EstimateIO="8331.43" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="600038000" LogicalOp="Clustered Index Scan" NodeId="27" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="8496.44" TableCardinality="600038000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Index="[L_SHIPDATE_CLUIDX]" IndexKind="Clustered" /> <Predicate> <ScalarOperator ScalarString="PROBE([Opt_Bitmap1022],[tpch].[dbo].[LINEITEM].[L_ORDERKEY],N'[IN ROW]')"> <Intrinsic FunctionName="PROBE"> <ScalarOperator> <Identifier> <ColumnReference Column="Opt_Bitmap1022" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="N'[IN ROW]'" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </ComputeScalar> </RelOp> </Parallelism> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Hash> </RelOp> </Hash> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Hash> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Sort> </RelOp> </StreamAggregate> </RelOp> </Sort> </RelOp> </QueryPlan> </StmtSimple> <StmtSimple StatementCompId="1" StatementEstRows="25" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="3027.38" StatementText="/* TPC_H Query 5 - Local Supplier Volume */&#xD;&#xA;SELECT N_NAME, SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)) AS REVENUE&#xD;&#xA;FROM CUSTOMER, ORDERS, LINEITEM, SUPPLIER, NATION, REGION&#xD;&#xA;WHERE C_CUSTKEY = O_CUSTKEY AND L_ORDERKEY = O_ORDERKEY AND L_SUPPKEY = S_SUPPKEY AND&#xD;&#xA; C_NATIONKEY = S_NATIONKEY AND S_NATIONKEY = N_NATIONKEY AND N_REGIONKEY = R_REGIONKEY&#xD;&#xA; AND R_NAME = 'ASIA' AND O_ORDERDATE &gt;= '1994-01-01' AND O_ORDERDATE &lt; CONVERT(DATE,DATEADD(YY, 1, '1994-01-01'))&#xD;&#xA;GROUP BY N_NAME ORDER BY REVENUE DESC&#xD;&#xA;" StatementType="SELECT" QueryHash="0x5E7489BB771B438A" QueryPlanHash="0xC26C78FFA054BEDC"> <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> <QueryPlan CachedPlanSize="160" CompileTime="219" CompileCPU="219" CompileMemory="3472"> <RelOp AvgRowSize="40" EstimateCPU="0.00028115" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="3027.38"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1020" /> </OutputList> <MemoryFractions Input="0.5" Output="1" /> <Sort Distinct="false"> <OrderBy> <OrderByColumn Ascending="false"> <ColumnReference Column="Expr1020" /> </OrderByColumn> </OrderBy> <RelOp AvgRowSize="40" EstimateCPU="7.25E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Aggregate" NodeId="1" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="3027.37"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1020" /> </OutputList> <StreamAggregate> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1020" /> <ScalarOperator ScalarString="SUM([partialagg1025])"> <Aggregate AggType="SUM" Distinct="false"> <ScalarOperator> <Identifier> <ColumnReference Column="partialagg1025" /> </Identifier> </ScalarOperator> </Aggregate> </ScalarOperator> </DefinedValue> </DefinedValues> <GroupBy> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </GroupBy> <RelOp AvgRowSize="40" EstimateCPU="0.00113648" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Sort" NodeId="2" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="3027.37"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1025" /> </OutputList> <MemoryFractions Input="1.35467E-05" Output="0.5" /> <Sort Distinct="false"> <OrderBy> <OrderByColumn Ascending="true"> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OrderByColumn> </OrderBy> <RelOp AvgRowSize="40" EstimateCPU="0.0285131" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="3027.36"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1025" /> </OutputList> <Parallelism> <RelOp AvgRowSize="40" EstimateCPU="14.6117" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Partial Aggregate" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="3027.33"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="partialagg1025" /> </OutputList> <MemoryFractions Input="0" Output="0" /> <Hash> <DefinedValues> <DefinedValue> <ColumnReference Column="partialagg1025" /> <ScalarOperator ScalarString="SUM([Expr1024])"> <Aggregate AggType="SUM" Distinct="false"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1024" /> </Identifier> </ScalarOperator> </Aggregate> </ScalarOperator> </DefinedValue> </DefinedValues> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </HashKeysBuild> <BuildResidual> <ScalarOperator ScalarString="[tpch].[dbo].[NATION].[N_NAME] = [tpch].[dbo].[NATION].[N_NAME]"> <Compare CompareOp="IS"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </BuildResidual> <RelOp AvgRowSize="40" EstimateCPU="21.3373" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="8213430" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="3012.72"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1024" /> </OutputList> <MemoryFractions Input="0.0763404" Output="0.109298" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </HashKeysProbe> <ProbeResidual> <ScalarOperator ScalarString="[tpch].[dbo].[SUPPLIER].[S_NATIONKEY]=[tpch].[dbo].[NATION].[N_NATIONKEY] AND [tpch].[dbo].[LINEITEM].[L_SUPPKEY]=[tpch].[dbo].[SUPPLIER].[S_SUPPKEY]"> <Logical Operation="AND"> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </Logical> </ScalarOperator> </ProbeResidual> <RelOp AvgRowSize="15" EstimateCPU="0.879938" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000000" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2.16699"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </PartitionColumns> <RelOp AvgRowSize="15" EstimateCPU="0.275039" EstimateIO="1.01201" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000000" LogicalOp="Index Scan" NodeId="7" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.28705" TableCardinality="1000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_SUPPKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Column="S_NATIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[SUPPLIER]" Index="[S_NATIONKEY_IDX]" IndexKind="NonClustered" /> </IndexScan> </RelOp> </Parallelism> </RelOp> <RelOp AvgRowSize="48" EstimateCPU="7.52779" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4511700" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2989.21"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1024" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </PartitionColumns> <RelOp AvgRowSize="48" EstimateCPU="255.788" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4511700" LogicalOp="Inner Join" NodeId="9" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2981.69"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Column="Expr1024" /> </OutputList> <MemoryFractions Input="0.622109" Output="0.890688" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </HashKeysProbe> <ProbeResidual> <ScalarOperator ScalarString="[tpch].[dbo].[LINEITEM].[L_ORDERKEY]=[tpch].[dbo].[ORDERS].[O_ORDERKEY]"> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </Identifier> </ScalarOperator> </Compare> </ScalarOperator> </ProbeResidual> <RelOp AvgRowSize="44" EstimateCPU="5.07979" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3461420" LogicalOp="Bitmap Create" NodeId="10" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="622.322"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Bitmap> <DefinedValues> <DefinedValue> <ColumnReference Column="Bitmap1031" /> </DefinedValue> </DefinedValues> <HashKeys> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </HashKeys> <RelOp AvgRowSize="44" EstimateCPU="5.07979" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3461420" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="622.322"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </PartitionColumns> <RelOp AvgRowSize="44" EstimateCPU="45.8785" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3461420" LogicalOp="Inner Join" NodeId="12" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="617.242"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <MemoryFractions Input="0.923355" Output="0.301551" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </HashKeysProbe> <RelOp AvgRowSize="40" EstimateCPU="4.05094" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3000000" LogicalOp="Bitmap Create" NodeId="13" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="270.56"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Bitmap> <DefinedValues> <DefinedValue> <ColumnReference Column="Bitmap1030" /> </DefinedValue> </DefinedValues> <HashKeys> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </HashKeys> <RelOp AvgRowSize="40" EstimateCPU="4.05094" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3000000" LogicalOp="Repartition Streams" NodeId="14" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="270.56"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </PartitionColumns> <RelOp AvgRowSize="40" EstimateCPU="21.6147" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3000000" LogicalOp="Inner Join" NodeId="15" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="266.509"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <MemoryFractions Input="0.92366" Output="0.000304209" /> <Hash> <DefinedValues /> <HashKeysBuild> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </HashKeysBuild> <HashKeysProbe> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </HashKeysProbe> <RelOp AvgRowSize="36" EstimateCPU="0.0285204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5" LogicalOp="Bitmap Create" NodeId="16" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.0390239"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Bitmap> <DefinedValues> <DefinedValue> <ColumnReference Column="Bitmap1029" /> </DefinedValue> </DefinedValues> <HashKeys> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </HashKeys> <RelOp AvgRowSize="36" EstimateCPU="0.0285204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5" LogicalOp="Distribute Streams" NodeId="17" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0390239"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <Parallelism PartitioningType="Broadcast"> <RelOp AvgRowSize="36" EstimateCPU="0.0001045" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5" LogicalOp="Inner Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0105035"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </OutputList> <NestedLoops Optimized="false"> <OuterReferences> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </OuterReferences> <RelOp AvgRowSize="40" EstimateCPU="0.0001845" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25" LogicalOp="Clustered Index Scan" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0033095" TableCardinality="25"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NATIONKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_NAME" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[NATION]" Index="[PK_N_NATIONKEY]" IndexKind="Clustered" /> </IndexScan> </RelOp> <RelOp AvgRowSize="32" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="20" EstimateRewinds="4" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0070775" TableCardinality="5"> <OutputList /> <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues /> <Object Database="[tpch]" Schema="[dbo]" Table="[REGION]" Index="[PK_R_REGIONKEY]" IndexKind="Clustered" /> <SeekPredicates> <SeekPredicateNew> <SeekKeys> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_REGIONKEY" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[tpch].[dbo].[NATION].[N_REGIONKEY]"> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[NATION]" Column="N_REGIONKEY" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekKeys> </SeekPredicateNew> </SeekPredicates> <Predicate> <ScalarOperator ScalarString="[tpch].[dbo].[REGION].[R_NAME]='ASIA'"> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[REGION]" Column="R_NAME" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="'ASIA'" /> </ScalarOperator> </Compare> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </NestedLoops> </RelOp> </Parallelism> </RelOp> </Bitmap> </RelOp> <RelOp AvgRowSize="15" EstimateCPU="4.12504" EstimateIO="240.731" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15000000" LogicalOp="Clustered Index Scan" NodeId="21" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="244.856" TableCardinality="15000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </OutputList> <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_CUSTKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Index="[PK_C_CUSTKEY]" IndexKind="Clustered" /> <Predicate> <ScalarOperator ScalarString="PROBE([Bitmap1029],[tpch].[dbo].[CUSTOMER].[C_NATIONKEY],N'[IN ROW]')"> <Intrinsic FunctionName="PROBE"> <ScalarOperator> <Identifier> <ColumnReference Column="Bitmap1029" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[CUSTOMER]" Column="C_NATIONKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="N'[IN ROW]'" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Bitmap> </RelOp> <RelOp AvgRowSize="19" EstimateCPU="19.5486" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="22755700" LogicalOp="Repartition Streams" NodeId="23" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="300.804"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </PartitionColumns> <RelOp AvgRowSize="19" EstimateCPU="6.25785" EstimateIO="274.997" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="22755700" LogicalOp="Clustered Index Seek" NodeId="24" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="281.255" TableCardinality="150000000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </OutputList> <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Index="[O_ORDERDATE_CLUIDX]" IndexKind="Clustered" /> <SeekPredicates> <SeekPredicateNew> <SeekKeys> <StartRange ScanType="GE"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1994-01-01'"> <Const ConstValue="'1994-01-01'" /> </ScalarOperator> </RangeExpressions> </StartRange> <EndRange ScanType="LT"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_ORDERDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1995-01-01'"> <Const ConstValue="'1995-01-01'" /> </ScalarOperator> </RangeExpressions> </EndRange> </SeekKeys> </SeekPredicateNew> </SeekPredicates> <Predicate> <ScalarOperator ScalarString="PROBE([Bitmap1030],[tpch].[dbo].[ORDERS].[O_CUSTKEY],N'[IN ROW]')"> <Intrinsic FunctionName="PROBE"> <ScalarOperator> <Identifier> <ColumnReference Column="Bitmap1030" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[ORDERS]" Column="O_CUSTKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="N'[IN ROW]'" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </Parallelism> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Bitmap> </RelOp> <RelOp AvgRowSize="27" EstimateCPU="3.36898" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134759000" LogicalOp="Compute Scalar" NodeId="26" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="2103.58"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Column="Expr1024" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1024" /> <ScalarOperator ScalarString="[tpch].[dbo].[LINEITEM].[L_EXTENDEDPRICE]*((1.000000000000000e+000)-[tpch].[dbo].[LINEITEM].[L_DISCOUNT])"> <Arithmetic Operation="MULT"> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> </Identifier> </ScalarOperator> <ScalarOperator> <Arithmetic Operation="SUB"> <ScalarOperator> <Const ConstValue="(1.000000000000000e+000)" /> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </Identifier> </ScalarOperator> </Arithmetic> </ScalarOperator> </Arithmetic> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp AvgRowSize="35" EstimateCPU="192.035" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134759000" LogicalOp="Repartition Streams" NodeId="27" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2100.21"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </OutputList> <Parallelism PartitioningType="Hash"> <PartitionColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </PartitionColumns> <RelOp AvgRowSize="35" EstimateCPU="37.0588" EstimateIO="1871.11" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134759000" LogicalOp="Clustered Index Seek" NodeId="28" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1908.17" TableCardinality="600038000"> <OutputList> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </OutputList> <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false"> <DefinedValues> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SUPPKEY" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_EXTENDEDPRICE" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_DISCOUNT" /> </DefinedValue> </DefinedValues> <Object Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Index="[L_SHIPDATE_CLUIDX]" IndexKind="Clustered" /> <SeekPredicates> <SeekPredicateNew> <SeekKeys> <StartRange ScanType="GE"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SHIPDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1993-12-19'"> <Const ConstValue="'1993-12-19'" /> </ScalarOperator> </RangeExpressions> </StartRange> <EndRange ScanType="LT"> <RangeColumns> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_SHIPDATE" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'1995-06-12'"> <Const ConstValue="'1995-06-12'" /> </ScalarOperator> </RangeExpressions> </EndRange> </SeekKeys> </SeekPredicateNew> </SeekPredicates> <Predicate> <ScalarOperator ScalarString="PROBE([Bitmap1031],[tpch].[dbo].[LINEITEM].[L_ORDERKEY],N'[IN ROW]')"> <Intrinsic FunctionName="PROBE"> <ScalarOperator> <Identifier> <ColumnReference Column="Bitmap1031" /> </Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[tpch]" Schema="[dbo]" Table="[LINEITEM]" Column="L_ORDERKEY" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="N'[IN ROW]'" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </Predicate> </IndexScan> </RelOp> </Parallelism> </RelOp> </ComputeScalar> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Hash> </RelOp> </Hash> </RelOp> </Parallelism> </RelOp> </Sort> </RelOp> </StreamAggregate> </RelOp> </Sort> </RelOp> </QueryPlan> </StmtSimple> </Statements> </Batch> </BatchSequence> </ShowPlanXML>