Problem using IF EXISTS(SELECT * FROM MYVIEW)

• gcresse

  SSCrazy

  Points: 2286

  More actions

  June 17, 2011 at 10:54 am

  #1340597

  You want the xml plan?

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 17, 2011 at 11:01 am

  #1340601

  We want the Actual Execution Plan saved as an XML file (.sqlplan extension).

  From the article with some relevant items in bold:

  To save an execution plan by using SQL Server Management Studio options

  Generate either an estimated execution plan or an actual execution plan by using Management Studio. For more information, see How to: Display the Estimated Execution Plan or How to: Display an Actual Execution Plan.

  In the Execution plan tab of the results pane, right-click the graphical execution plan, and choose Save Execution Plan As.

  As an alternative, you can also choose Save Execution Plan As on the File menu.

  In the Save As dialog box, make sure that the Save as type is set to Execution Plan Files (*.sqlplan).

  In the File name box provide a name, in the format <name>.sqlplan, and then click Save.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• gcresse

  SSCrazy

  Points: 2286

  More actions

  June 17, 2011 at 11:09 am

  #1340602

  Ok. Well, I can't get an Actual exection plan on the If Exists or If Count > 0 because the code never completes, so here is the Estimated plan on that:

  <?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.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

  <BatchSequence>

  <Batch>

  <Statements>

  <StmtCond StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="41.9649" StatementText="if exists(select LotIngrLotKey from va_negingrs) " StatementType="COND WITH QUERY" QueryHash="0x311E555CE10AF0BB" QueryPlanHash="0xD7E9BBE77147DB52">

  <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />

  <Condition>

  <QueryPlan CachedPlanSize="248" CompileTime="738" CompileCPU="738" CompileMemory="8032">

  <RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="41.9649">

  <OutputList>

  <ColumnReference Column="Expr1030" />

  </OutputList>

  <ComputeScalar>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1030" />

  <ScalarOperator ScalarString="CASE WHEN [Expr1031] THEN (1) ELSE (0) END">

  <IF>

  <Condition>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1031" />

  </Identifier>

  </ScalarOperator>

  </Condition>

  <Then>

  <ScalarOperator>

  <Const ConstValue="(1)" />

  </ScalarOperator>

  </Then>

  <Else>

  <ScalarOperator>

  <Const ConstValue="(0)" />

  </ScalarOperator>

  </Else>

  </IF>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="41.9649">

  <OutputList>

  <ColumnReference Column="Expr1031" />

  </OutputList>

  <NestedLoops Optimized="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1031" />

  </DefinedValue>

  </DefinedValues>

  <ProbeColumn>

  <ColumnReference Column="Expr1031" />

  </ProbeColumn>

  <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Constant Scan" NodeId="2" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">

  <OutputList />

  <ConstantScan />

  </RelOp>

  <RelOp AvgRowSize="9" EstimateCPU="0.0285013" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="41.9648">

  <OutputList />

  <Parallelism>

  <RelOp AvgRowSize="9" EstimateCPU="0.184102" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="4" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="41.9363">

  <OutputList />

  <Filter StartupExpression="false">

  <RelOp AvgRowSize="41" EstimateCPU="0.65216" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Left Outer Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="41.9363">

  <OutputList>

  <ColumnReference Column="Expr1019" />

  <ColumnReference Column="Expr1024" />

  </OutputList>

  <NestedLoops Optimized="false">

  <OuterReferences>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </OuterReferences>

  <RelOp AvgRowSize="36" EstimateCPU="11.4568" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Aggregate" NodeId="6" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="41.8998">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Column="Expr1019" />

  </OutputList>

  <MemoryFractions Input="0.495517" Output="1" />

  <Hash>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1019" />

  <ScalarOperator ScalarString="SUM([DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty])">

  <Aggregate AggType="SUM" Distinct="false">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  </Aggregate>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <HashKeysBuild>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </HashKeysBuild>

  <BuildResidual>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkHdr].[wkhLotKey] as [H1].[wkhLotKey] = [DataWhse].[dbo].[WorkHdr].[wkhLotKey] as [H1].[wkhLotKey] AND [DataWhse].[dbo].[WorkIngr].[wkiCompItemID] as [I1].[wkiCompItemID] = [DataWhse].[dbo].[WorkIngr].[wkiCompItemID] as [I1].[wkiCompItemID] AND [DataWhse].[dbo].[WorkIngr].[wkiUOM] as [I1].[wkiUOM] = [DataWhse].[dbo].[WorkIngr].[wkiUOM] as [I1].[wkiUOM] AND [DataWhse].[dbo].[WorkIngr].[wkiTransDate] as [I1].[wkiTransDate] = [DataWhse].[dbo].[WorkIngr].[wkiTransDate] as [I1].[wkiTransDate] AND [DataWhse].[dbo].[WorkIngr].[wkiPodKey] as [I1].[wkiPodKey] = [DataWhse].[dbo].[WorkIngr].[wkiPodKey] as [I1].[wkiPodKey] AND [DataWhse].[dbo].[WorkIngr].[wkiIntKey] as [I1].[wkiIntKey] = [DataWhse].[dbo].[WorkIngr].[wkiIntKey] as [I1].[wkiIntKey] AND [dv_wrp].[dbo].[ProdOrd].[PohPlantID] = [dv_wrp].[dbo].[ProdOrd].[PohPlantID] AND [dv_wrp].[dbo].[ProdOrd].[PohProdOrder] = [dv_wrp].[dbo].[ProdOrd].[PohProdOrder]">

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="AND">

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </BuildResidual>

  <RelOp AvgRowSize="59" EstimateCPU="1.82642" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1248150" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="30.443">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </PartitionColumns>

  <RelOp AvgRowSize="59" EstimateCPU="2.33101" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1248150" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="28.6165">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <MemoryFractions Input="0.656845" Output="0.338393" />

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </HashKeysProbe>

  <RelOp AvgRowSize="25" EstimateCPU="0.234565" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380874" LogicalOp="Bitmap Create" NodeId="9" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="2.15998">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Opt_Bitmap1042" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </HashKeys>

  <RelOp AvgRowSize="25" EstimateCPU="0.234565" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380874" LogicalOp="Repartition Streams" NodeId="10" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2.15998">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="25" EstimateCPU="0.776988" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380874" LogicalOp="Inner Join" NodeId="11" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.92541">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <MemoryFractions Input="1" Output="0.343155" />

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </HashKeysProbe>

  <RelOp AvgRowSize="25" EstimateCPU="0.10849" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="147847" LogicalOp="Repartition Streams" NodeId="12" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.503075">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="25" EstimateCPU="0.0203486" EstimateIO="0.374236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="147847" LogicalOp="Index Scan" NodeId="13" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.394585" TableCardinality="147847">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Index="[idx_ProdOrd]" IndexKind="NonClustered" />

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  <RelOp AvgRowSize="15" EstimateCPU="0.178719" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380874" LogicalOp="Repartition Streams" NodeId="14" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.645345">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="15" EstimateCPU="0.0523898" EstimateIO="0.414236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380874" LogicalOp="Index Scan" NodeId="15" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.466626" TableCardinality="380874">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Index="[idx_ProdOrdDtl]" TableReferenceId="2" IndexKind="NonClustered" />

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="46" EstimateCPU="1.25653" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Repartition Streams" NodeId="17" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="24.1256">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="46" EstimateCPU="1.85957" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Inner Join" NodeId="18" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="22.869">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <MemoryFractions Input="0.267837" Output="0.137984" />

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </HashKeysProbe>

  <RelOp AvgRowSize="15" EstimateCPU="0.0656126" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="94097.5" LogicalOp="Bitmap Create" NodeId="19" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.747661">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </OutputList>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Opt_Bitmap1041" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </HashKeys>

  <RelOp AvgRowSize="15" EstimateCPU="0.0656126" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="94097.5" LogicalOp="Repartition Streams" NodeId="20" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.747661">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </PartitionColumns>

  <RelOp AvgRowSize="15" EstimateCPU="0.232331" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="94097.5" LogicalOp="Inner Join" NodeId="21" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.682049">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </OutputList>

  <MemoryFractions Input="0.343155" Output="0.0753181" />

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </HashKeysProbe>

  <RelOp AvgRowSize="11" EstimateCPU="0.049664" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="70657" LogicalOp="Repartition Streams" NodeId="22" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.231413">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="11" EstimateCPU="0.00973496" EstimateIO="0.172014" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="70657" LogicalOp="Index Scan" NodeId="23" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.181749" TableCardinality="70657">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </OutputList>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Index="[idx_Lot2]" IndexKind="NonClustered" />

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  <RelOp AvgRowSize="15" EstimateCPU="0.0658428" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="94681" LogicalOp="Repartition Streams" NodeId="24" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.218302">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="15" EstimateCPU="0.0130383" EstimateIO="0.139421" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="94681" LogicalOp="Index Scan" NodeId="25" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.15246" TableCardinality="94681">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </OutputList>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Index="[idx_WorkHdrUnique]" Alias="[H1]" IndexKind="NonClustered" />

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="46" EstimateCPU="1.25037" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Repartition Streams" NodeId="27" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="20.2618">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </PartitionColumns>

  <RelOp AvgRowSize="46" EstimateCPU="1.70669" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Inner Join" NodeId="28" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="19.0114">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <MemoryFractions Input="0.0753181" Output="0.0281055" />

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </HashKeysProbe>

  <RelOp AvgRowSize="11" EstimateCPU="0.030396" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6329.75" LogicalOp="Bitmap Create" NodeId="29" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.148427">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </OutputList>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Opt_Bitmap1040" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </HashKeys>

  <RelOp AvgRowSize="11" EstimateCPU="0.030396" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6329.75" LogicalOp="Repartition Streams" NodeId="30" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.148427">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </PartitionColumns>

  <RelOp AvgRowSize="11" EstimateCPU="0.00330729" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6329.75" LogicalOp="Inner Join" NodeId="31" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.118031">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </OutputList>

  <NestedLoops Optimized="false" WithUnorderedPrefetch="true">

  <OuterReferences>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  <ColumnReference Column="Expr1043" />

  </OuterReferences>

  <RelOp AvgRowSize="19" EstimateCPU="0.0289099" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="169" LogicalOp="Distribute Streams" NodeId="33" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0331186">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </OutputList>

  <Parallelism PartitioningType="RoundRobin">

  <RelOp AvgRowSize="19" EstimateCPU="0.0003429" EstimateIO="0.00386574" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="169" LogicalOp="Clustered Index Scan" NodeId="34" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00420864" TableCardinality="169">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </OutputList>

  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Index="[PK_Variety]" IndexKind="Clustered" />

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  <RelOp AvgRowSize="11" EstimateCPU="0.0001982" EstimateIO="0.003125" EstimateRebinds="168" EstimateRewinds="0" EstimateRows="37.4541" LogicalOp="Index Seek" NodeId="35" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0816047" TableCardinality="8391">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </OutputList>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Index="[idx_ItmVariety]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmVarietyCode" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="[dv_wrp].[dbo].[Variety].[VarVarietyCode]">

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="46" EstimateCPU="1.16646" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Repartition Streams" NodeId="36" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="17.1563">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </PartitionColumns>

  <RelOp AvgRowSize="46" EstimateCPU="0.498763" EstimateIO="14.6387" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1180880" LogicalOp="Index Seek" NodeId="38" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="15.1374" TableCardinality="21223600">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Index="[idx_WorkIngr1]" Alias="[I1]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <StartRange ScanType="GT">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="'2009-12-31 00:00:00.000'">

  <Const ConstValue="'2009-12-31 00:00:00.000'" />

  </ScalarOperator>

  </RangeExpressions>

  </StartRange>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  <Predicate>

  <ScalarOperator ScalarString="([DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty]<(0.00000) OR [DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty]>(0.00000)) AND PROBE([Opt_Bitmap1040],[DataWhse].[dbo].[WorkIngr].[wkiCompItemID] as [I1].[wkiCompItemID],N'[IN ROW]') AND PROBE([Opt_Bitmap1041],[DataWhse].[dbo].[WorkIngr].[wkiHdrID] as [I1].[wkiHdrID],N'[IN ROW]') AND PROBE([Opt_Bitmap1042],[DataWhse].[dbo].[WorkIngr].[wkiPodKey] as [I1].[wkiPodKey],N'[IN ROW]')">

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="OR">

  <ScalarOperator>

  <Compare CompareOp="LT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="GT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Opt_Bitmap1040" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  <ScalarOperator>

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Opt_Bitmap1041" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  <ScalarOperator>

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Opt_Bitmap1042" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  <RelOp AvgRowSize="24" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="3.33333" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="46" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.0365299">

  <OutputList>

  <ColumnReference Column="Expr1024" />

  </OutputList>

  <StreamAggregate>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1024" />

  <ScalarOperator ScalarString="SUM([DataWhse].[dbo].[WorkPcts].[wkpCompQty] as [P2].[wkpCompQty])">

  <Aggregate AggType="SUM" Distinct="false">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </Identifier>

  </ScalarOperator>

  </Aggregate>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <RelOp AvgRowSize="16" EstimateCPU="6.57503E-06" EstimateIO="0" EstimateRebinds="3.33333" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="47" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0365251">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </OutputList>

  <NestedLoops Optimized="false">

  <OuterReferences>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhHdrID" />

  </OuterReferences>

  <RelOp AvgRowSize="11" EstimateCPU="0.00015873" EstimateIO="0.003125" EstimateRebinds="3.33333" EstimateRewinds="0" EstimateRows="1.57297" LogicalOp="Index Seek" NodeId="48" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0141124" TableCardinality="94681">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhHdrID" />

  </OutputList>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhHdrID" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Index="[idx_WorkHdr1]" Alias="[H2]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhLotKey" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkHdr].[wkhLotKey] as [H1].[wkhLotKey]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  <RelOp AvgRowSize="20" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="5.81621" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="49" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0223782" TableCardinality="140103000">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </OutputList>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Index="[idx_WorkPcts2]" Alias="[P2]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpIntKey" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkHdr].[wkhHdrID] as [H2].[wkhHdrID]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhHdrID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkIngr].[wkiIntKey] as [I1].[wkiIntKey]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  <Predicate>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkPcts].[wkpPodKey] as [P2].[wkpPodKey]=[DataWhse].[dbo].[WorkIngr].[wkiPodKey] as [I1].[wkiPodKey] AND [DataWhse].[dbo].[WorkPcts].[wkpCompQty] as [P2].[wkpCompQty]<>(0.00000)">

  <Logical Operation="AND">

  <ScalarOperator>

  <Compare CompareOp="EQ">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpPodKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="NE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </StreamAggregate>

  </RelOp>

  </NestedLoops>

  </RelOp>

  <Predicate>

  <ScalarOperator ScalarString="round(([Expr1019]*(1000.))/[Expr1024],(5))<(0.000000)">

  <Compare CompareOp="LT">

  <ScalarOperator>

  <Intrinsic FunctionName="round">

  <ScalarOperator>

  <Arithmetic Operation="DIV">

  <ScalarOperator>

  <Arithmetic Operation="MULT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1019" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(1000.)" />

  </ScalarOperator>

  </Arithmetic>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1024" />

  </Identifier>

  </ScalarOperator>

  </Arithmetic>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(5)" />

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.000000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Predicate>

  </Filter>

  </RelOp>

  </Parallelism>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </ComputeScalar>

  </RelOp>

  </QueryPlan>

  </Condition>

  <Then>

  <Statements>

  <StmtSimple StatementCompId="2" StatementId="2" StatementText="print 'exists" StatementType="PRINT" />

  </Statements>

  </Then>

  </StmtCond>

  </Statements>

  </Batch>

  </BatchSequence>

  </ShowPlanXML>

  And here is the Actual execution plan for the IF NOT IN... statement:

  <?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.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

  <BatchSequence>

  <Batch>

  <Statements>

  <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="19.1752" StatementText="IF 0 NOT IN (SELECT ISNULL(LotIngrLotKey,0) FROM va_negingrs) " StatementType="COND WITH QUERY" QueryHash="0x7EAC74D2DF791B06" QueryPlanHash="0x1033434333B2B2C0">

  <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />

  <QueryPlan DegreeOfParallelism="16" MemoryGrant="48768" CachedPlanSize="208" CompileTime="505" CompileCPU="505" CompileMemory="6224">

  <RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="19.1752">

  <OutputList>

  <ColumnReference Column="Expr1031" />

  </OutputList>

  <ComputeScalar>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1031" />

  <ScalarOperator ScalarString="CASE WHEN [Expr1032] IS NULL THEN (1) ELSE (0) END">

  <IF>

  <Condition>

  <ScalarOperator>

  <Compare CompareOp="IS">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1032" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="NULL" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Condition>

  <Then>

  <ScalarOperator>

  <Const ConstValue="(1)" />

  </ScalarOperator>

  </Then>

  <Else>

  <ScalarOperator>

  <Const ConstValue="(0)" />

  </ScalarOperator>

  </Else>

  </IF>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="19.1752">

  <OutputList>

  <ColumnReference Column="Expr1032" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  </RunTimeInformation>

  <NestedLoops Optimized="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1032" />

  </DefinedValue>

  </DefinedValues>

  <ProbeColumn>

  <ColumnReference Column="Expr1032" />

  </ProbeColumn>

  <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Constant Scan" NodeId="2" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  </RunTimeInformation>

  <ConstantScan />

  </RelOp>

  <RelOp AvgRowSize="9" EstimateCPU="0.0285013" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="19.1752">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  </RunTimeInformation>

  <Parallelism>

  <RelOp AvgRowSize="9" EstimateCPU="0.00152889" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="4" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="19.1467">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Filter StartupExpression="false">

  <RelOp AvgRowSize="41" EstimateCPU="0.00541591" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Left Outer Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="19.1467">

  <OutputList>

  <ColumnReference Column="Expr1019" />

  <ColumnReference Column="Expr1024" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <NestedLoops Optimized="false">

  <OuterReferences>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </OuterReferences>

  <RelOp AvgRowSize="32" EstimateCPU="0.0285453" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="17.7085">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Column="Expr1019" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </PartitionColumns>

  <OrderBy>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </OrderByColumn>

  </OrderBy>

  <RelOp AvgRowSize="32" EstimateCPU="0.00142524" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Aggregate" NodeId="7" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="17.6799">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Column="Expr1019" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <StreamAggregate>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1019" />

  <ScalarOperator ScalarString="SUM([DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty])">

  <Aggregate AggType="SUM" Distinct="false">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  </Aggregate>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <GroupBy>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </GroupBy>

  <RelOp AvgRowSize="54" EstimateCPU="0.0285522" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="17.6799">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </PartitionColumns>

  <OrderBy>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OrderByColumn>

  </OrderBy>

  <RelOp AvgRowSize="54" EstimateCPU="0.00541557" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33333" LogicalOp="Inner Join" NodeId="9" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.6514">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <NestedLoops Optimized="false">

  <RelOp AvgRowSize="9" EstimateCPU="0.0285013" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="10" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317844">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Broadcast">

  <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="11" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="70658">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues />

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Index="[PK_Lot]" IndexKind="Clustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Lot]" Column="LotKey" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="(0)">

  <Const ConstValue="(0)" />

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  <RelOp AvgRowSize="54" EstimateCPU="1.15481" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.33312" LogicalOp="Inner Join" NodeId="12" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.6196">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <NestedLoops Optimized="false">

  <Predicate>

  <ScalarOperator ScalarString="[dv_wrp].[dbo].[Item].[ItmVarietyCode]=[dv_wrp].[dbo].[Variety].[VarVarietyCode]">

  <Compare CompareOp="EQ">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmVarietyCode" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Predicate>

  <RelOp AvgRowSize="63" EstimateCPU="0.00699043" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.20562" LogicalOp="Inner Join" NodeId="13" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.6141">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmVarietyCode" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <NestedLoops Optimized="false" WithOrderedPrefetch="true">

  <OuterReferences>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Column="Expr1043" />

  </OuterReferences>

  <RelOp AvgRowSize="54" EstimateCPU="0.105234" EstimateIO="0.00140766" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.3024" LogicalOp="Sort" NodeId="15" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="17.6101">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <MemoryFractions Input="0.262267" Output="1" />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Sort Distinct="false">

  <OrderBy>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </OrderByColumn>

  <OrderByColumn Ascending="true">

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OrderByColumn>

  </OrderBy>

  <RelOp AvgRowSize="54" EstimateCPU="0.154013" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="17.5035">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <MemoryFractions Input="0.436874" Output="0.737733" />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="156" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="505" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="660" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="145" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="202" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="371" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="203" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="182" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="155" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </HashKeysProbe>

  <RelOp AvgRowSize="46" EstimateCPU="0.0413926" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Bitmap Create" NodeId="17" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="16.8464">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="156" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="505" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="660" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="145" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="202" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="371" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="182" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="155" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="203" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Bitmap1042" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </HashKeys>

  <RelOp AvgRowSize="46" EstimateCPU="0.0413926" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Repartition Streams" NodeId="18" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="16.8464">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="156" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="505" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="660" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="145" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="202" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="371" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="182" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="155" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="203" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="46" EstimateCPU="0.286329" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Inner Join" NodeId="19" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="16.805">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <MemoryFractions Input="0.919052" Output="0.563126" />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="4" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="142" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="191" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="204" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="663" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="174" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="158" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="477" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="188" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </HashKeysProbe>

  <RelOp AvgRowSize="42" EstimateCPU="0.0442849" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Bitmap Create" NodeId="20" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="15.8733">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="4" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="142" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="191" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="204" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="663" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="174" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="158" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="477" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="188" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Bitmap1041" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </HashKeys>

  <RelOp AvgRowSize="42" EstimateCPU="0.0442849" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Repartition Streams" NodeId="21" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="15.8733">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="4" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="142" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="191" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="204" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="663" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="351" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="195" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="174" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="158" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="477" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="188" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="42" EstimateCPU="0.0377771" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="15.829">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <MemoryFractions Input="1" Output="0.0809485" />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="2371" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="26" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="376" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Hash>

  <DefinedValues />

  <HashKeysBuild>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </HashKeysBuild>

  <HashKeysProbe>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </HashKeysProbe>

  <RelOp AvgRowSize="11" EstimateCPU="0.0286745" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="582.585" LogicalOp="Bitmap Create" NodeId="23" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.0320336">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Bitmap>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Opt_Bitmap1036" />

  </DefinedValue>

  </DefinedValues>

  <HashKeys>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </HashKeys>

  <RelOp AvgRowSize="11" EstimateCPU="0.0286745" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="582.585" LogicalOp="Repartition Streams" NodeId="24" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0320336">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </PartitionColumns>

  <RelOp AvgRowSize="11" EstimateCPU="9.97304E-05" EstimateIO="0.00325937" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="582.585" LogicalOp="Index Seek" NodeId="25" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0033591" TableCardinality="94681">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="514" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="68" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhHdrID" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Index="[idx_WorkHdr1]" Alias="[H1]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H1]" Column="wkhLotKey" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="(0)">

  <Const ConstValue="(0)" />

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="46" EstimateCPU="0.0413926" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Repartition Streams" NodeId="26" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="15.7592">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="69" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="2371" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="27" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="377" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </PartitionColumns>

  <RelOp AvgRowSize="46" EstimateCPU="0.498763" EstimateIO="14.6387" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13378.8" LogicalOp="Index Seek" NodeId="28" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="15.1374" TableCardinality="21223600">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="3" ActualRows="420" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="183" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="311" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="27" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="199" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="232" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="350" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="963" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="210" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="171" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiUOM" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Index="[idx_WorkIngr1]" Alias="[I1]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <StartRange ScanType="GT">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiTransDate" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="'2009-12-31 00:00:00.000'">

  <Const ConstValue="'2009-12-31 00:00:00.000'" />

  </ScalarOperator>

  </RangeExpressions>

  </StartRange>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  <Predicate>

  <ScalarOperator ScalarString="([DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty]<(0.00000) OR [DataWhse].[dbo].[WorkIngr].[wkiCompQty] as [I1].[wkiCompQty]>(0.00000)) AND PROBE([Opt_Bitmap1036],[DataWhse].[dbo].[WorkIngr].[wkiHdrID] as [I1].[wkiHdrID],N'[IN ROW]')">

  <Logical Operation="AND">

  <ScalarOperator>

  <Logical Operation="OR">

  <ScalarOperator>

  <Compare CompareOp="LT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="GT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  <ScalarOperator>

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Opt_Bitmap1036" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiHdrID" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="15" EstimateCPU="0.178727" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380894" LogicalOp="Repartition Streams" NodeId="31" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.645356">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="4" ActualRows="27" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="15" EstimateCPU="0.0523926" EstimateIO="0.414236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="380894" LogicalOp="Index Scan" NodeId="32" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.466629" TableCardinality="380894">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="81" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="104" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodPohKey" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Index="[idx_ProdOrdDtl]" TableReferenceId="2" IndexKind="NonClustered" />

  <Predicate>

  <ScalarOperator ScalarString="PROBE([Bitmap1041],[dv_wrp].[dbo].[ProdOrdDtl].[PodKey],N'[IN ROW]')">

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Bitmap1041" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrdDtl]" Column="PodKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Bitmap>

  </RelOp>

  <RelOp AvgRowSize="25" EstimateCPU="0.108496" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="147859" LogicalOp="Repartition Streams" NodeId="34" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.503083">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="5" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="25" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Parallelism PartitioningType="Hash">

  <PartitionColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </PartitionColumns>

  <RelOp AvgRowSize="25" EstimateCPU="0.0203502" EstimateIO="0.374236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="147859" LogicalOp="Index Scan" NodeId="35" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.394586" TableCardinality="147859">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="8" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="9" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="15" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="7" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="3" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="2" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="13" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="14" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="10" ActualRows="174" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="16" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="11" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="12" ActualRows="275" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="4" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="6" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohPlantID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohProdOrder" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Index="[idx_ProdOrd]" IndexKind="NonClustered" />

  <Predicate>

  <ScalarOperator ScalarString="PROBE([Bitmap1042],[dv_wrp].[dbo].[ProdOrd].[PohKey],N'[IN ROW]')">

  <Intrinsic FunctionName="PROBE">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Bitmap1042" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[ProdOrd]" Column="PohKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="N'[IN ROW]'" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  </Parallelism>

  </RelOp>

  </Hash>

  </RelOp>

  </Sort>

  </RelOp>

  <RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.102585" EstimateRewinds="4.19988" EstimateRows="1" LogicalOp="Index Seek" NodeId="37" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00396332" TableCardinality="8391">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmVarietyCode" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmVarietyCode" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Index="[idx_Item2]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Item]" Column="ItmItemCode" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkIngr].[wkiCompItemID] as [I1].[wkiCompItemID]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiCompItemID" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  </NestedLoops>

  </RelOp>

  <RelOp AvgRowSize="19" EstimateCPU="0.0002644" EstimateIO="0.00394424" EstimateRebinds="0" EstimateRewinds="4.20534" EstimateRows="169" LogicalOp="Clustered Index Scan" NodeId="38" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00532053" TableCardinality="169">

  <OutputList>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Column="VarVarietyCode" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[dv_wrp]" Schema="[dbo]" Table="[Variety]" Index="[PK_Variety]" IndexKind="Clustered" />

  </IndexScan>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </Parallelism>

  </RelOp>

  </StreamAggregate>

  </RelOp>

  </Parallelism>

  </RelOp>

  <RelOp AvgRowSize="24" EstimateCPU="0.00010028" EstimateIO="0.01" EstimateRebinds="3.33321" EstimateRewinds="0" EstimateRows="1" LogicalOp="Lazy Spool" NodeId="43" Parallel="true" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="1.4383">

  <OutputList>

  <ColumnReference Column="Expr1024" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="9" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="10" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <Spool>

  <RelOp AvgRowSize="24" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="3.33321" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="44" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1.39453">

  <OutputList>

  <ColumnReference Column="Expr1024" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <StreamAggregate>

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Column="Expr1024" />

  <ScalarOperator ScalarString="SUM([DataWhse].[dbo].[WorkPcts].[wkpCompQty] as [P2].[wkpCompQty])">

  <Aggregate AggType="SUM" Distinct="false">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </Identifier>

  </ScalarOperator>

  </Aggregate>

  </ScalarOperator>

  </DefinedValue>

  </DefinedValues>

  <RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="3.33321" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="45" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.39453">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <NestedLoops Optimized="false">

  <OuterReferences>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpHdrID" />

  </OuterReferences>

  <RelOp AvgRowSize="24" EstimateCPU="0.0577072" EstimateIO="0.254977" EstimateRebinds="3.33321" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="46" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="1.09995" TableCardinality="140103000">

  <OutputList>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpHdrID" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </OutputList>

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpHdrID" />

  </DefinedValue>

  <DefinedValue>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </DefinedValue>

  </DefinedValues>

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Index="[idx_WorkPcts3]" Alias="[P2]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpIntKey" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkIngr].[wkiIntKey] as [I1].[wkiIntKey]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiIntKey" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  <Predicate>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkPcts].[wkpPodKey] as [P2].[wkpPodKey]=[DataWhse].[dbo].[WorkIngr].[wkiPodKey] as [I1].[wkiPodKey] AND ([DataWhse].[dbo].[WorkPcts].[wkpCompQty] as [P2].[wkpCompQty]<(0.00000) OR [DataWhse].[dbo].[WorkPcts].[wkpCompQty] as [P2].[wkpCompQty]>(0.00000))">

  <Logical Operation="AND">

  <ScalarOperator>

  <Compare CompareOp="EQ">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpPodKey" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkIngr]" Alias="[I1]" Column="wkiPodKey" />

  </Identifier>

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Logical Operation="OR">

  <ScalarOperator>

  <Compare CompareOp="LT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  <ScalarOperator>

  <Compare CompareOp="GT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpCompQty" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.00000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </Logical>

  </ScalarOperator>

  </Predicate>

  </IndexScan>

  </RelOp>

  <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3.33321" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="47" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00437586" TableCardinality="94681">

  <OutputList />

  <RunTimeInformation>

  <RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="10" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="16" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="13" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="15" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="12" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

  </RunTimeInformation>

  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

  <DefinedValues />

  <Object Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Index="[idx_WorkHdr1]" Alias="[H2]" IndexKind="NonClustered" />

  <SeekPredicates>

  <SeekPredicateNew>

  <SeekKeys>

  <Prefix ScanType="EQ">

  <RangeColumns>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhLotKey" />

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkHdr]" Alias="[H2]" Column="wkhHdrID" />

  </RangeColumns>

  <RangeExpressions>

  <ScalarOperator ScalarString="(0)">

  <Const ConstValue="(0)" />

  </ScalarOperator>

  <ScalarOperator ScalarString="[DataWhse].[dbo].[WorkPcts].[wkpHdrID] as [P2].[wkpHdrID]">

  <Identifier>

  <ColumnReference Database="[DataWhse]" Schema="[dbo]" Table="[WorkPcts]" Alias="[P2]" Column="wkpHdrID" />

  </Identifier>

  </ScalarOperator>

  </RangeExpressions>

  </Prefix>

  </SeekKeys>

  </SeekPredicateNew>

  </SeekPredicates>

  </IndexScan>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </StreamAggregate>

  </RelOp>

  </Spool>

  </RelOp>

  </NestedLoops>

  </RelOp>

  <Predicate>

  <ScalarOperator ScalarString="round(([Expr1019]*(1000.))/[Expr1024],(5))<(0.000000)">

  <Compare CompareOp="LT">

  <ScalarOperator>

  <Intrinsic FunctionName="round">

  <ScalarOperator>

  <Arithmetic Operation="DIV">

  <ScalarOperator>

  <Arithmetic Operation="MULT">

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1019" />

  </Identifier>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(1000.)" />

  </ScalarOperator>

  </Arithmetic>

  </ScalarOperator>

  <ScalarOperator>

  <Identifier>

  <ColumnReference Column="Expr1024" />

  </Identifier>

  </ScalarOperator>

  </Arithmetic>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(5)" />

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="" />

  </ScalarOperator>

  </Intrinsic>

  </ScalarOperator>

  <ScalarOperator>

  <Const ConstValue="(0.000000)" />

  </ScalarOperator>

  </Compare>

  </ScalarOperator>

  </Predicate>

  </Filter>

  </RelOp>

  </Parallelism>

  </RelOp>

  </NestedLoops>

  </RelOp>

  </ComputeScalar>

  </RelOp>

  </QueryPlan>

  </StmtSimple>

  </Statements>

  </Batch>

  </BatchSequence>

  </ShowPlanXML>

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 17, 2011 at 11:28 am

  #1340614

  Something did not come through correctly through the copy/paste/website translation...can you please save the execution plans on your local disk and attach them to the thread?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• gcresse

  SSCrazy

  Points: 2286

  More actions

  June 17, 2011 at 12:13 pm

  #1340647

  Here are the 2 plan files attached

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 17, 2011 at 1:15 pm

  #1340682

  Thanks for posting back.

  I looked at the article to see how you arrived at a query that used "IF 0 NOT IN" because I had never seen that as an alternative to IF EXISTS and learned that http://www.pafumi.net/Tips_for_Effective_Queries.html is actually geared towards Oracle...but you got lucky in that it helped so it's all good 😀

  As far as the plans...if you cannot provide an Actual Plan for both then I can't do much of a comparison. Two Estimated plans won't do much good either. If you can run the first query to get the actual plan I would love to see it.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato