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

  • Identical Query. A select with one column condition. Selecting from a view. The view is bad, joining eight tables and another view. :crazy: That wasn't my call.

    In production, we are getting horrendous performance. 41 minutes for query. In test, it is subsecond.

    Using SQL Compare, database schemas verified identical for all relevant tables and views. Indexes identical. Data in test is a copy of a recent production backup and is substantially identical. Only difference is that the test DB is in simple recovery mode.

    Query plan shows production query creating bitmaps and doing the clustered index scan on a probe of one of those bitmaps; the test query plan shows a simple index seek on a nonclustered, and no bitmap creation anywhere in the query plan.

    Tried all of this:

    1. Recreating index used in test query plan in prod

    2. Freeing procedure cache with DBCC FREEPROCCACHE

    3. Setting ARITHABORT expressly ON and OFF (no difference)

    I am completely stumped as executive mgmt. does a slow burn.

    Thoughts?

    Thanks

    John

  • May be you can try updating stats on all the 8 base tables. Also check fragmentation on all the 8 tables. Verify the MAXDOP settings on both the machines.

  • ssismaddy (9/25/2013)


    May be you can try updating stats on all the 8 base tables. Also check fragmentation on all the 8 tables. Verify the MAXDOP settings on both the machines.

    Checked the fragmentation on all 8 tables. Nothing bad (worst table is 35%). MAXDOP is set to 4 on both machines.

    Update stats may take a while and I'm hesitant unless we are off-hours.

    Thanks.

    John.

  • You need to find out what the differences are between test and production. Perhaps you have a bad plan cached on production? Perhaps you have a missing index on one of the 8 references tables? Is the referenced view the same in test and production?

    If you haven't seen it, Erland Sommarskog hosts an excellent utility called SQL trace. It pulls a lot of useful information that may help you troubleshoot the problem. The only thing is that you're going to have to troubleshoot it in production because the problem doesn't exist in test. Anyway, have a look: http://www.sommarskog.se/sqlutil/sqltrace.html

    HTH

  • Probably stale stats. Update stats on the tables involved with full scan. But need execution plans from both to make anything more than a wild guess.

    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
  • Hi. I freed the entire procedure cache -- twice. I also compared the schema of test and production using SQL Compare, including indexes, which are identical for all tables. I am restoring a copy of the prod database to another test server. The problem did not restore; the test server still runs perfectly.

    Stumped doesn't begin to describe my thoughts. :w00t:

  • johntam (9/26/2013)


    Hi. I freed the entire procedure cache -- twice. I also compared the schema of test and production using SQL Compare, including indexes, which are identical for all tables. I am restoring a copy of the prod database to another test server. The problem did not restore; the test server still runs perfectly.

    Stumped doesn't begin to describe my thoughts. :w00t:

    Good Plan (names changed to protect the innocent:

    StmtText

    --------

    Compute Scalar(DEFINE: ([Expr1023]=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, [Expr1027]='A', [Expr1028]=(0)))

    |--Parallelism(Gather Streams)

    |--Nested Loops(Left Outer Join, OUTER REFERENCES: ([xh].[client], [xh].[parent_cas_id], [Expr1032]))

    |--Nested Loops(Inner Join, OUTER REFERENCES: ([r].[att_value], [xh].[client]))

    | |--Hash Match(Inner Join, HASH: ([r].[client], [r].[att_value])=([xh].[client], [al].[article]), RESIDUAL: ([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]))

    | | |--Parallelism(Distribute Streams, Broadcast Partitioning)

    | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aglrelvalue].[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE] AS [r]), SEEK: ([r].[rel_attr_id]='Q50' AND [r].[attribute_id]='D0') ORDERED FORWARD)

    | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([al].[agrtid], [Expr1042]) OPTIMIZED WITH UNORDERED PREFETCH)

    | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xal].[sequence_no], [xal].[subscription_id], [xh].[client], [Expr1041]) OPTIMIZED WITH UNORDERED PREFETCH)

    | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([ai].[sequence_no], [ai].[subscription_id], [xh].[client], [Expr1040]) WITH UNORDERED PREFETCH)

    | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([ai].[participant_id], [xh].[client], [Expr1039]) OPTIMIZED WITH UNORDERED PREFETCH)

    | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([ai].[agree_item_id], [ai].[client], [Expr1038]) OPTIMIZED WITH UNORDERED PREFETCH)

    | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xh].[apar_id], [xh].[client], [Expr1037]) OPTIMIZED WITH UNORDERED PREFETCH)

    | | | | | | | |--Compute Scalar(DEFINE: ([Expr1032]=CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)))

    | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([cas].[apar_id], [cas].[client], [Expr1036]) WITH UNORDERED PREFETCH)

    | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([cas].[apar_id], [cas].[client], [Expr1035]) WITH UNORDERED PREFETCH)

    | | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xc].[apar_id], [xc].[client], [Expr1034]) WITH UNORDERED PREFETCH)

    | | | | | | | | | | |--Parallelism(Repartition Streams, RoundRobin Partitioning)

    | | | | | | | | | | | |--Index Scan(OBJECT: ([TESTSERVER].[dbo].[aq1extacuheader].[IX_EXTACUHEADER_ORGLEVEL_INCL_APAR_CLIENT_PARENTCAS] AS [xc]), WHERE: ([TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xc].[parent_cas_id]=[@2]))

    | | | | | | | | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[acuheader].[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID] AS [cas]), SEEK: ([cas].[apar_id]=[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id] AND [cas].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client] AND [cas].[status]='N') ORDERED FORWARD)

    | | | | | | | | | |--Clustered Index Seek(OBJECT: ([TESTSERVER].[dbo].[acuheader].[PK_acuheader] AS [c]), SEEK: ([c].[apar_id]=[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] AND [c].[client]=[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]) ORDERED FORWARD)

    | | | | | | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1extacuheader].[IX_aq1extacuheader_aparid_client_parentcasid_orglevel] AS [xh]), SEEK: ([xh].[apar_id]=[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] AND [xh].[client]=[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]) ORDERED FORWARD)

    | | | | | | | |--Filter(WHERE: (STARTUP EXPR([@0]=[@1])))

    | | | | | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1agreeitem].[IX_AQ1AGREEITEM_APARID_CLIENT] AS [ai]), SEEK: ([ai].[apar_id]=[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xh].[apar_id] AND [ai].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    | | | | | | |--Clustered Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1agreeitem].[aiaq1agreeitem0] AS [ai]), SEEK: ([ai].[client]=[TESTSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client] AND [ai].[agree_item_id]=[TESTSERVER].[dbo].[aq1agreeitem].[agree_item_id] as [ai].[agree_item_id]) LOOKUP ORDERED FORWARD)

    | | | | | |--Clustered Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1participant].[PK_aq1participant] AS [p]), SEEK: ([p].[participant_id]=[TESTSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id] AND [p].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    | | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1extuidetail].[IX_AQ1EXTUIDETAIL_SUBSCRIPTID_SEQNO_CLIENT_NEXTWEARBEGIN_PICKUPFLAG_INCL] AS [xal]), SEEK: ([xal].[subscription_id]=[TESTSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id] AND [xal].[sequence_no]=[TESTSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no] AND [xal].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    | | | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[auiinvdetail].[IX_AUIINVDETAIL_CLIENT_SUBID_SEQ_AGRTID_CREATEDT_DATETO_APARID] AS [al]), SEEK: ([al].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [al].[subscription_id]=[TESTSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id] AND [al].[sequence_no]=[TESTSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]) ORDERED FORWARD)

    | | |--Clustered Index Seek(OBJECT: ([TESTSERVER].[dbo].[auiinvdetail].[PK_auiinvdetail ] AS [al]), SEEK: ([al].[agrtid]=[TESTSERVER].[dbo].[auiinvdetail].[agrtid] as [al].[agrtid]) LOOKUP ORDERED FORWARD)

    | |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aglrelvalue].[aiaglrelvalue3] AS [r2]), SEEK: ([r2].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [r2].[att_value]=[TESTSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value] AND [r2].[rel_attr_id]='JL85'), WHERE: ([TESTSERVER].[dbo].[aglrelvalue].[attribute_id] as [r2].[attribute_id]='D0') ORDERED FORWARD)

    |--Filter(WHERE: (STARTUP EXPR([Expr1032]=(3))))

    |--Index Seek(OBJECT: ([TESTSERVER].[dbo].[aq1extacuheader].[IX_aq1extacuheader_aparid_client_parentcasid_orglevel] AS [xh2]), SEEK: ([xh2].[apar_id]=[TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] AND [xh2].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    BAD Plan:

    StmtText

    --------

    Compute Scalar(DEFINE: ([Expr1023]=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, [Expr1027]='A', [Expr1028]=(0)))

    |--Parallelism(Gather Streams)

    |--Nested Loops(Left Outer Join, OUTER REFERENCES: ([xh].[client], [xh].[parent_cas_id], [Expr1032], [Expr1048]) WITH UNORDERED PREFETCH)

    |--Nested Loops(Inner Join, OUTER REFERENCES: ([ai].[participant_id], [xh].[client], [Expr1047]) OPTIMIZED WITH UNORDERED PREFETCH)

    | |--Hash Match(Inner Join, HASH: ([xh].[client], [xh].[apar_id], [xal].[subscription_id], [xal].[sequence_no])=([ai].[client], [ai].[apar_id], [ai].[subscription_id], [ai].[sequence_no]), RESIDUAL: ([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]))

    | | |--Bitmap(HASH: ([xh].[client], [xh].[apar_id], [xal].[subscription_id], [xal].[sequence_no]), DEFINE: ([Bitmap1046]))

    | | | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS: ([xh].[client], [xh].[apar_id], [xal].[subscription_id], [xal].[sequence_no]))

    | | | |--Hash Match(Inner Join, HASH: ([xh].[client], [al].[subscription_id], [al].[sequence_no])=([xal].[client], [xal].[subscription_id], [xal].[sequence_no]), RESIDUAL: ([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]))

    | | | |--Bitmap(HASH: ([xh].[client], [al].[subscription_id], [al].[sequence_no]), DEFINE: ([Bitmap1045]))

    | | | | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS: ([xh].[client], [al].[subscription_id], [al].[sequence_no]))

    | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([r2].[att_value], [xh].[client], [Expr1044]) WITH UNORDERED PREFETCH)

    | | | | |--Compute Scalar(DEFINE: ([Expr1032]=CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)))

    | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([cas].[apar_id], [cas].[client], [Expr1043]) WITH UNORDERED PREFETCH)

    | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xc].[apar_id], [r2].[client], [Expr1042]) WITH UNORDERED PREFETCH)

    | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xc].[apar_id], [r2].[client], [Expr1041]) WITH UNORDERED PREFETCH)

    | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([xc].[apar_id], [xc].[client], [Expr1040]) WITH UNORDERED PREFETCH)

    | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([r2].[client]))

    | | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES: ([r].[att_value], [r].[client]))

    | | | | | | | | | | |--Parallelism(Distribute Streams, RoundRobin Partitioning)

    | | | | | | | | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[aglrelvalue].[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE] AS [r]), SEEK: ([r].[rel_attr_id]='Q50' AND [r].[attribute_id]='D0') ORDERED FORWARD)

    | | | | | | | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[aglrelvalue].[aiaglrelvalue2] AS [r2]), SEEK: ([r2].[attribute_id]='D0' AND [r2].[att_value]=[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value] AND [r2].[rel_attr_id]='JL85'), WHERE: ([PRODSERVER].[dbo].[aglrelvalue].[client] as [r].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]) ORDERED FORWARD)

    | | | | | | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[aq1extacuheader].[IX_AQ1EXTACUHEADER_CLIENT_PARENTCASID] AS [xc]), SEEK: ([xc].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client] AND [xc].[parent_cas_id]=[@2]) ORDERED FORWARD)

    | | | | | | | | |--Clustered Index Seek(OBJECT: ([PRODSERVER].[dbo].[aq1extacuheader].[PK_aq1extacuheader] AS [xc]), SEEK: ([xc].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id] AND [xc].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client]) LOOKUP ORDERED FORWARD)

    | | | | | | | |--Clustered Index Seek(OBJECT: ([PRODSERVER].[dbo].[acuheader].[PK_acuheader] AS [c]), SEEK: ([c].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id] AND [c].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]) ORDERED FORWARD)

    | | | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[acuheader].[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID] AS [cas]), SEEK: ([cas].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id] AND [cas].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client] AND [cas].[status]='N') ORDERED FORWARD)

    | | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[aq1extacuheader].[IX_aq1extacuheader_aparid_client_parentcasid_orglevel] AS [xh]), SEEK: ([xh].[apar_id]=[PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] AND [xh].[client]=[PRODSERVER].[dbo].[acuheader].[client] as [cas].[client]) ORDERED FORWARD)

    | | | | |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[auiinvdetail].[IX_AUIINVDETAIL_ARTICLE_APARID_STATUS_SUBSCRIPTID_SEQNO_CLIENT_INCL] AS [al]), SEEK: ([al].[article]=[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r2].[att_value]), WHERE: ([PRODSERVER].[dbo].[auiinvdetail].[client] as [al].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    | | | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS: ([xal].[client], [xal].[subscription_id], [xal].[sequence_no]))

    | | | |--Index Scan(OBJECT: ([PRODSERVER].[dbo].[aq1extuidetail].[IX_AQ1EXTUIDETAIL_PICKUPFLAG_SUBSCRIPTIONID_SEQNO_NEXTWEARBEGIN_INCL] AS [xal]), WHERE: (PROBE([Bitmap1045],[PRODSERVER].[dbo].[aq1extuidetail].[client] as [xal].[client],[PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id],[PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no])))

    | | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS: ([ai].[client], [ai].[apar_id], [ai].[subscription_id], [ai].[sequence_no]))

    | | |--Filter(WHERE: (STARTUP EXPR([@0]=[@1])))

    | | |--Clustered Index Scan(OBJECT: ([PRODSERVER].[dbo].[aq1agreeitem].[aiaq1agreeitem0] AS [ai]), WHERE: (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])))

    | |--Clustered Index Seek(OBJECT: ([PRODSERVER].[dbo].[aq1participant].[PK_aq1participant] AS [p]), SEEK: ([p].[participant_id]=[PRODSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id] AND [p].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

    |--Filter(WHERE: (STARTUP EXPR([Expr1032]=(3))))

    |--Index Seek(OBJECT: ([PRODSERVER].[dbo].[aq1extacuheader].[IX_aq1extacuheader_aparid_client_parentcasid_orglevel] AS [xh2]), SEEK: ([xh2].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] AND [xh2].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]) ORDERED FORWARD)

  • So while the query is executing on Prod, do you see any blocks? is the query on running state all the time or suspended? do you know what is the wait type if its suspended?

  • Plans in XML format please. The text format is awfully hard to read and is missing about 99% of the 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
  • GilaMonster (9/26/2013)


    Plans in XML format please. The text format is awfully hard to read and is missing about 99% of the information.

    In test, nothing. It flies.

    In production, I see CXPACKET only, no blocks, just boatloads of parallelism.

  • 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>

  • 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>

  • 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
  • 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.

  • 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.

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply