SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Query on identical objects different systems, A performs speedy with index seek, B performs poorly...


Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

Author
Message
SQLBlimp
SQLBlimp
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 500
Bad Query XML:


<?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.1" Build="10.0.5500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="185.487" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="216.809" StatementText="SELECT 'A' AS tab ,0 AS tag ,t.subscription_id ,t.article ,t.control ,t.frequency ,t.start_day ,t.participant_id ,t.legacy_part_id ,t.description ,t.quantity ,t.zone ,t.pickup_flag ,t.date_from ,t.date_to ,t.wear_select_dt ,t.manually_closed ,t.apar_id ,t.apar_name ,t.ext_apar_ref ,t.parent_cas_id ,t.art_descr ,t.agree_item_id ,t.report_flag ,t.customer_key ,t.dose_category ,t.dosimeter_use ,t.cust ,t.sequence_no ,t.level ,t.product_line ,t.al_create_date ,t.al_date_to FROM aq1viagreeitem t WHERE 1=1 AND t.parent_cas_id='10922' ORDER BY 1 " StatementType="SELECT" ParameterizedText="(@0 int,@1 int,@2 varchar(8000))select 'A' as tab , 0 as tag , t . subscription_id , t . article , t . control , t . frequency , t . start_day , t . participant_id , t . legacy_part_id , t . description , t . quantity , t . zone , t . pickup_flag , t . date_from , t . date_to , t . wear_select_dt , t . manually_closed , t . apar_id , t . apar_name , t . ext_apar_ref , t . parent_cas_id , t . art_descr , t . agree_item_id , t . report_flag , t . customer_key , t . dose_category , t . dosimeter_use , t . cust , t . sequence_no , t . level , t . product_line , t . al_create_date , t . al_date_to from aq1viagreeitem t where @0 = @1 and t . parent_cas_id = @2 order by 1" QueryHash="0xFBA5C36153A5C81E" QueryPlanHash="0x1331CB96C51B9261">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="320" CompileTime="5174" CompileCPU="4765" CompileMemory="67584">
<RelOp AvgRowSize="389" EstimateCPU="1.85487E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="216.809">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1027" />
<ColumnReference Column="Expr1028" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [Expr1032]=(1) THEN [PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(2) THEN [PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(3) THEN [PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh2].[parent_cas_id] ELSE NULL END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1027" />
<ScalarOperator ScalarString="'A'">
<Const ConstValue="'A'" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1028" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="398" EstimateCPU="0.0305867" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="216.809">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism>
<RelOp AvgRowSize="398" EstimateCPU="0.000193834" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Left Outer Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="216.778">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
<ColumnReference Column="Expr1048" />
</OuterReferences>
<RelOp AvgRowSize="394" EstimateCPU="0.000371907" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="216.204">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1047" />
</OuterReferences>
<RelOp AvgRowSize="361" EstimateCPU="37.0299" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="355.892" LogicalOp="Inner Join" NodeId="7" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="215.039">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<MemoryFractions Input="0.742123" Output="0.999494" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [PRODSERVER].[dbo].[aq1agreeitem].[apar_id] as [ai].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xh].[apar_id] AND [PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id]=[PRODSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id] AND [PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]=[PRODSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="276" EstimateCPU="2.94011" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Bitmap Create" NodeId="8" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="36.239">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1046" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</HashKeys>
<RelOp AvgRowSize="276" EstimateCPU="2.94011" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="36.239">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</PartitionColumns>
<RelOp AvgRowSize="276" EstimateCPU="0.805394" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Inner Join" NodeId="10" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="33.2989">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extuidetail].[client] as [xal].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [PRODSERVER].[dbo].[auiinvdetail].[subscription_id] as [al].[subscription_id]=[PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id] AND [PRODSERVER].[dbo].[auiinvdetail].[sequence_no] as [al].[sequence_no]=[PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="28" EstimateCPU="7.73356" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1153450" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="19.0591">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="28" EstimateCPU="0.317239" EstimateIO="11.0083" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1153450" LogicalOp="Index Scan" NodeId="12" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="11.3255" TableCardinality="1153450">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Index="[IX_AQ1EXTUIDETAIL_SUBSCRIPTID_SEQNO_CLIENT_NEXTWEARBEGIN_PICKUPFLAG_INCL]" Alias="[xal]" IndexKind="NonClustered" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1045],[PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id],[PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no],[PRODSERVER].[dbo].[aq1extuidetail].[client] as [xal].[client])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1045" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="277" EstimateCPU="7.64282" EstimateIO="0.00281532" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Sort" NodeId="13" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="13.4344">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<MemoryFractions Input="0.952176" Output="0.245598" />
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="277" EstimateCPU="2.83776" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Bitmap Create" NodeId="14" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="5.78877">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1045" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</HashKeys>
<RelOp AvgRowSize="277" EstimateCPU="2.83776" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Repartition Streams" NodeId="15" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="5.78877">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</PartitionColumns>
<RelOp AvgRowSize="277" EstimateCPU="0.377021" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.95102">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1044" />
</OuterReferences>
<RelOp AvgRowSize="102" EstimateCPU="1.7388E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Compute Scalar" NodeId="19" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.929839">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1032" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="98" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="20" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.929837">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1043" />
</OuterReferences>
<RelOp AvgRowSize="81" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.709109">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1042" />
</OuterReferences>
<RelOp AvgRowSize="57" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="24" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.484086">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Column="Expr1041" />
</OuterReferences>
<RelOp AvgRowSize="57" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="26" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.263187">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Column="Expr1040" />
</OuterReferences>
<RelOp AvgRowSize="60" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="28" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0385034">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</OuterReferences>
<RelOp AvgRowSize="48" EstimateCPU="1.045E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="29" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0350722">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</OuterReferences>
<RelOp AvgRowSize="35" EstimateCPU="0.0285045" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="30" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317876">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<Parallelism PartitioningType="RoundRobin">
<RelOp AvgRowSize="35" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5241110">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE]" Alias="[r2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_attr_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="attribute_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'JL85'">
<Const ConstValue="'JL85'" />
</ScalarOperator>
<ScalarOperator ScalarString="'D0'">
<Const ConstValue="'D0'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="26" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="32" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5241110">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[aiaglrelvalue2]" Alias="[r]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="attribute_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_attr_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'D0'">
<Const ConstValue="'D0'" />
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r2].[att_value]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'Q50'">
<Const ConstValue="'Q50'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="29" EstimateCPU="0.000233507" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Index Seek" NodeId="33" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00335851" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_AQ1EXTACUHEADER_CLIENT_PARENTCASID]" Alias="[xc]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@2]">
<Identifier>
<ColumnReference Column="@2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="35" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.224611" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
</OutputList>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[PK_aq1extacuheader]" Alias="[xc]" TableReferenceId="-1" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="39" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.220826" TableCardinality="408583">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID]" Alias="[cas]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="status" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'N'">
<Const ConstValue="'N'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="40" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="40" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.22495" TableCardinality="408583">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[PK_acuheader]" Alias="[c]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="30" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="41" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.220655" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="195" EstimateCPU="0.005863" EstimateIO="0.181644" EstimateRebinds="57.6699" EstimateRewinds="10.8822" EstimateRows="5187.27" LogicalOp="Index Seek" NodeId="45" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="1.47098" TableCardinality="1153450">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[IX_AUIINVDETAIL_ARTICLE_APARID_STATUS_SUBSCRIPTID_SEQNO_CLIENT_INCL]" Alias="[al]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r2].[att_value]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[auiinvdetail].[client] as [al].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
<RelOp AvgRowSize="118" EstimateCPU="19.9154" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Repartition Streams" NodeId="47" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="141.77">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</PartitionColumns>
<RelOp AvgRowSize="118" EstimateCPU="0.301304" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Filter" NodeId="48" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="121.855">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="118" EstimateCPU="1.18373" EstimateIO="120.37" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Clustered Index Scan" NodeId="49" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="121.554" TableCardinality="4304350">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[aiaq1agreeitem0]" Alias="[ai]" IndexKind="Clustered" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1046],[PRODSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client],[PRODSERVER].[dbo].[aq1agreeitem].[apar_id] as [ai].[apar_id],[PRODSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id],[PRODSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1046" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[@0]=[@1]">
<Identifier>
<ColumnReference Column="ConstExpr1029">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@0" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="354.892" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="52" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.16475" TableCardinality="7828500">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Index="[PK_aq1participant]" Alias="[p]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="17" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="184.487" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="53" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.573779">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="184.487" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="54" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.57369" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1032]=(3)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@2" ParameterCompiledValue="'10922'" />
<ColumnReference Column="@1" ParameterCompiledValue="(1)" />
<ColumnReference Column="@0" ParameterCompiledValue="(1)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>


SQLBlimp
SQLBlimp
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 500
GOOD QUERY XML:


<?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.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="2.36611" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="21.8508" StatementText="select 'A' as tab , 0 as tag , t . subscription_id , t . article , t . control , t . frequency , t . start_day , t . participant_id , t . legacy_part_id , t . description , t . quantity , t . zone , t . pickup_flag , t . date_from , t . date_to , t . wear_select_dt , t . manually_closed , t . apar_id , t . apar_name , t . ext_apar_ref , t . parent_cas_id , t . art_descr , t . agree_item_id , t . report_flag , t . customer_key , t . dose_category , t . dosimeter_use , t . cust , t . sequence_no , t . level , t . product_line , t . al_create_date , t . al_date_to from aq1viagreeitem t where @0 = @1 and t . parent_cas_id = @2 order by 1" StatementType="SELECT" QueryHash="0xFBA5C36153A5C81E" QueryPlanHash="0x49F26EB3BE4CD1BD">
<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="2" MemoryGrant="9376" CachedPlanSize="344" CompileTime="3524" CompileCPU="575" CompileMemory="12504">
<RelOp AvgRowSize="388" EstimateCPU="2.36611E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="21.8508">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1027" />
<ColumnReference Column="Expr1028" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [Expr1032]=(1) THEN [TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(2) THEN [TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(3) THEN [TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh2].[parent_cas_id] ELSE NULL END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1027" />
<ScalarOperator ScalarString="'A'">
<Const ConstValue="'A'" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1028" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="397" EstimateCPU="0.0285532" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="21.8508">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="3459" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="397" EstimateCPU="4.94517E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Left Outer Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.8223">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OuterReferences>
<RelOp AvgRowSize="393" EstimateCPU="4.94517E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.8165">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</OuterReferences>
<RelOp AvgRowSize="387" EstimateCPU="0.0218003" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="21.813">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<MemoryFractions Input="0" Output="0" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[client] as [r].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [TESTSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value]=[TESTSERVER].[dbo].[auiinvdetail].[article] as [al].[article]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="26" EstimateCPU="0.0285039" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.031787">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1544" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1544" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp AvgRowSize="26" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="7" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5229330">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1544" 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="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE]" Alias="[r]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_attr_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="attribute_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'Q50'">
<Const ConstValue="'Q50'" />
</ScalarOperator>
<ScalarOperator ScalarString="'D0'">
<Const ConstValue="'D0'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="374" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.7594">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
<ColumnReference Column="Expr1042" />
</OuterReferences>
<RelOp AvgRowSize="228" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="11" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.7559">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1041" />
</OuterReferences>
<RelOp AvgRowSize="216" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="14" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="13.9214">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1040" />
</OuterReferences>
<RelOp AvgRowSize="201" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="10.104">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1039" />
</OuterReferences>
<RelOp AvgRowSize="168" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="19" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.06486">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Column="Expr1038" />
</OuterReferences>
<RelOp AvgRowSize="91" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.04446">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1037" />
</OuterReferences>
<RelOp AvgRowSize="71" EstimateCPU="2.26447E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Compute Scalar" NodeId="25" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.89477">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1032" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="67" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="26" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.89476">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1036" />
</OuterReferences>
<RelOp AvgRowSize="49" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="28" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.75098">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1035" />
</OuterReferences>
<RelOp AvgRowSize="30" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="30" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.60545">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Column="Expr1034" />
</OuterReferences>
<RelOp AvgRowSize="30" EstimateCPU="0.0286049" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Repartition Streams" NodeId="32" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1.49024">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="RoundRobin">
<RelOp AvgRowSize="30" EstimateCPU="0.224347" EstimateIO="1.13942" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Index Scan" NodeId="33" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.36377" TableCardinality="407760">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="236" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="6" 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="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_EXTACUHEADER_ORGLEVEL_INCL_APAR_CLIENT_PARENTCAS]" Alias="[xc]" IndexKind="NonClustered" />
<Predicate>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xc].[parent_cas_id]=[@2]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@2" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="34" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.143729" TableCardinality="407733">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID]" Alias="[cas]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="status" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'N'">
<Const ConstValue="'N'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="32" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="35" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.145429" TableCardinality="407733">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[PK_acuheader]" Alias="[c]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="30" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="36" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.143692" TableCardinality="407760">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="37" EstimateCPU="7.61972E-06" EstimateIO="0" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="27.2133" LogicalOp="Filter" NodeId="40" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.147116">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRebinds="121" ActualRewinds="0" ActualRows="1592" ActualEndOfScans="121" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="121" ActualRewinds="0" ActualRows="1867" ActualEndOfScans="121" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="true">
<RelOp AvgRowSize="37" EstimateCPU="0.000186935" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="27.2133" LogicalOp="Index Seek" NodeId="41" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.146771" TableCardinality="4246870">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="121" ActualExecutions="121" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="121" ActualExecutions="121" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[IX_AQ1AGREEITEM_APARID_CLIENT]" Alias="[ai]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xh].[apar_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[@0]=[@1]">
<Identifier>
<ColumnReference Column="ConstExpr1029">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@0" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="90" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="44" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.01783" TableCardinality="4246870">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[aiaq1agreeitem0]" Alias="[ai]" TableReferenceId="-1" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[agree_item_id] as [ai].[agree_item_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="68" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.03658" TableCardinality="7782800">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Index="[PK_aq1participant]" Alias="[p]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="participant_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="22" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="69" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.81485" TableCardinality="1148620">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Index="[IX_AQ1EXTUIDETAIL_SUBSCRIPTID_SEQNO_CLIENT_NEXTWEARBEGIN_PICKUPFLAG_INCL]" Alias="[xal]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="31" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="70" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.83186" TableCardinality="1148620">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1592" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1867" ActualExecutions="1867" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[IX_AUIINVDETAIL_CLIENT_SUBID_SEQ_AGRTID_CREATEDT_DATETO_APARID]" Alias="[al]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="166" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="72" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.00098" TableCardinality="1148620">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[PK_auiinvdetail ]" Alias="[al]" TableReferenceId="-1" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[auiinvdetail].[agrtid] as [al].[agrtid]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="27" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="1.36611" EstimateRows="1" LogicalOp="Index Seek" NodeId="81" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00349908" TableCardinality="5229330">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1592" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1867" ActualExecutions="1867" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[aiaglrelvalue3]" Alias="[r2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_attr_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'JL85'">
<Const ConstValue="'JL85'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[attribute_id] as [r2].[attribute_id]='D0'">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="attribute_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'D0'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="17" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="1.36611" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="82" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00575227">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="1591" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="1866" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="true">
<RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.36611" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="83" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00575113" TableCardinality="407760">
<OutputList>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />
<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />
<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="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="apar_id" />
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1032]=(3)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@2" ParameterCompiledValue="'10922'" ParameterRuntimeValue="'10922'" />
<ColumnReference Column="@1" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
<ColumnReference Column="@0" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>


GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88274 Visits: 45277
You're really not making this easy...

For anyone else who wants to have a look, plans are attached, edited to so that they're valid XML (had hidden illegal characters in them) and converted. Though I just noticed one of them is an estimated plan, so missing all the run-time information

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Attachments
Badplan.sqlplan (8 views, 376.00 KB)
GoodPlan.sqlplan (6 views, 172.00 KB)
SQLBlimp
SQLBlimp
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 500
Hi Gail...

Apologies for not making it easy. I am inexperienced at posting XML based query plans online. I can rerun the bad query in production but it impacts end users; checking to see if the trace I ran list night had a XML query plan.

Furthermore, I just had SSMS show me the XML query plan and cut/pasted it after substituting server names in order to protect my employer's security. How that can happen? I don't ask to challenge but rather to learn.

Thanks
John.
SQLBlimp
SQLBlimp
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 500
We reproduced the problem in part with the latest backup from production.

Updating stats on all of the affected tables with FULLSCAN solved the problem.

We will run this tonight in production. Then I will let all of you know what happened.

Thanks so much for helpful hints.
John.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88274 Visits: 45277
johntam (9/26/2013)
Updating stats on all of the affected tables with FULLSCAN solved the problem.


That's what I suspected. The plans showed different estimated row counts, so that was a second indication that the problem was stats-related.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


logitestus
logitestus
Mr or Mrs. 500
Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)

Group: General Forum Members
Points: 521 Visits: 522
Gail, In the interest of learning something new, do you know of a post which describes the accepted method for posting XML query plans?

Thanks!
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88274 Visits: 45277
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


logitestus
logitestus
Mr or Mrs. 500
Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)Mr or Mrs. 500 (521 reputation)

Group: General Forum Members
Points: 521 Visits: 522
Thank you very much, I have seen the link and sheepishly admit to reading the article but, I have never gotten to the bottom where the query plan details are.

I apologize for a time-wasting question (I don't believe in stupid questions but there are plenty of time-wasting/laziness questions.)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search