Query - Performance between dates

• jason 84805

  SSC Enthusiast

  Points: 186

  More actions

  February 5, 2018 at 8:15 am

  #343482

  Im running a query and it has numerous linked tables. I have entered a date parameter of one week (28/01/2018 to 03/02/2018) it took 12 minutes to complete. I then ran (28/01/2017 to 03/02/2018) it took 4 minutes. 
  Im in the UK and looking at the table the date field is DD/MM/YYYY. When I enter the dates in the query I have to enter the WHERE as (sqltbl.Datefield Between '2018/01/28' AND ''2018/02/03')
  I cannot understand why running just one week can take 12 mins and one year can take 4 mins. This is also happening on a different query (but still using the same date field)
  Any ideas please

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 5, 2018 at 8:29 am

  #1978561

  Maybe because it's returning 52 times as many rows?  Please post the query plan and the two actual execution plans.

  John

• jason 84805

  SSC Enthusiast

  Points: 186

  More actions

  February 5, 2018 at 8:43 am

  #1978566

  Due to the nature of the database - I cant post the actual query. But essentially it's using a pass through query in MS Access directly to the server and written as
  SET NOCOUNT ON SELECT field1, field2, field3, Date1 From sqlTBLone WHERE (field1 = 'something') and (Date1 Between '2018/01/28' AND ''2018/02/03')

  There's loads more tables with joins, but it's simply written as in the above example

• jason 84805

  SSC Enthusiast

  Points: 186

  More actions

  February 5, 2018 at 8:51 am

  #1978568

  John Mitchell-245523 - Monday, February 5, 2018 8:29 AM

  Maybe because it's returning 52 times as many rows?  Please post the query plan and the two actual execution plans.

  John

  Due to the nature of the database - I cant post the actual query. But essentially it's using a pass through query in MS Access directly to the server and written as
  SET NOCOUNT ON SELECT field1, field2, field3, Date1 From sqlTBLone WHERE (field1 = 'something') and (Date1 Between '2018/01/28' AND ''2018/02/03')

  There's loads more tables with joins, but it's simply written as in the above example

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  February 5, 2018 at 9:08 am

  #1978569

  jason 84805 - Monday, February 5, 2018 8:15 AM

  Im running a query and it has numerous linked tables. I have entered a date parameter of one week (28/01/2018 to 03/02/2018) it took 12 minutes to complete. I then ran (28/01/2017 to 03/02/2018) it took 4 minutes. 
  Im in the UK and looking at the table the date field is DD/MM/YYYY. When I enter the dates in the query I have to enter the WHERE as (sqltbl.Datefield Between '2018/01/28' AND ''2018/02/03')
  I cannot understand why running just one week can take 12 mins and one year can take 4 mins. This is also happening on a different query (but still using the same date field)
  Any ideas please

  I suggest that you compare the actual execution plans for the two queries and look for differences.
  Are your statistics up to date?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• drew.allen

  SSC Guru

  Points: 76944

  More actions

  February 5, 2018 at 9:09 am

  #1978572

  jason 84805 - Monday, February 5, 2018 8:51 AM

  John Mitchell-245523 - Monday, February 5, 2018 8:29 AM

  Maybe because it's returning 52 times as many rows?  Please post the query plan and the two actual execution plans.

  John

  Due to the nature of the database - I cant post the actual query. But essentially it's using a pass through query in MS Access directly to the server and written as
  SET NOCOUNT ON SELECT field1, field2, field3, Date1 From sqlTBLone WHERE (field1 = 'something') and (Date1 Between '2018/01/28' AND ''2018/02/03')

  There's loads more tables with joins, but it's simply written as in the above example

  Without the actual execution plans, it's pure guesswork.  If you cannot post the actual execution plan, there's not a whole lot that we can do.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  February 5, 2018 at 9:19 am

  #1978577

  I submit it is not guesswork (assuming no server load/blocking issues). It is what I call the "widely-varying-input" problem. Pay attention to that I am about to say, because it is a MAGIC BULLET for that class of queries (which is essentially ever report query ever written with start/end dates or a date comparison, and also situations where one "identifier" can get a few rows and another get 40% of all data, et al):

  IF YOU HAVE WIDELY-VARYING INPUTS TO A QUERY (see above indicators) YOU ABSOLUTELY MUST ENSURE SAID QUERY HAS OPTION (RECOMPILE) ON IT!!!

  You can't POSSIBLY want the same query plan on a query that has @StartDate and @EndDate when the first execution has yesterday and today and the next execution (using that stored query plan) has 19000101 and 99991231. The opposite order of first/second calls kills you to, just with a different plan.

  The above thing alone has made me look like I am a magician at MANY MANY clients.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 5, 2018 at 9:28 am

  #1978580

  TheSQLGuru - Monday, February 5, 2018 9:19 AM

  I submit it is not guesswork (assuming no server load/blocking issues). It is what I call the "widely-varying-input" problem. Pay attention to that I am about to say, because it is a MAGIC BULLET for that class of queries (which is essentially ever report query ever written with start/end dates or a date comparison, and also situations where one "identifier" can get a few rows and another get 40% of all data, et al):

  IF YOU HAVE WIDELY-VARYING INPUTS TO A QUERY (see above indicators) YOU ABSOLUTELY MUST ENSURE SAID QUERY HAS OPTION (RECOMPILE) ON IT!!!

  You can't POSSIBLY want the same query plan on a query that has @StartDate and @EndDate when the first execution has yesterday and today and the next execution (using that stored query plan) has 19000101 and 99991231. The opposite order of first/second calls kills you to, just with a different plan.

  The above thing alone has made me look like I am a magician at MANY MANY clients.

  Since he's running it from an Access front end, it sounds like an ad hoc query and therefore he shouldn't be seeing plan reuse at all, should he (except maybe with the same arguments for the dates)?

  Edit - of course the only way to know for certain is to look at the plans.

  John

• ScottPletcher

  SSC Guru

  Points: 100942

  More actions

  February 5, 2018 at 11:27 am

  #1978597

  What is the underlying table clustered on?  If it's clus on identity, you should seriously consider clustering instead by date first, esp. if you (almost) always look up by date, rather than ident.  You can add the ident to the end of the clus key to guarantee a unique key.

  That will reduce the time as much as possible across all queries when coming specifying a date.

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

• Grant Fritchey

  SSC Guru

  Points: 398679

  More actions

  February 5, 2018 at 1:11 pm

  #1978624

  Get a copy of SentryOne Plan Explorer. It's free. Anonymize the plans (it'll clean the query & everything) and then post those. Otherwise, everything everyone is saying is just random stabs in the dark. You can't get good assistance without providing us with information. With no information, it could be anything.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• jason 84805

  SSC Enthusiast

  Points: 186

  More actions

  February 12, 2018 at 7:17 am

  #1979414

  Grant Fritchey - Monday, February 5, 2018 1:11 PM

  Get a copy of SentryOne Plan Explorer. It's free. Anonymize the plans (it'll clean the query & everything) and then post those. Otherwise, everything everyone is saying is just random stabs in the dark. You can't get good assistance without providing us with information. With no information, it could be anything.

  I have SentryOne Explorer plan now, But Im have issues with the anonymize feature which as yet I havent resolved
  

• jason 84805

  SSC Enthusiast

  Points: 186

  More actions

  February 12, 2018 at 8:24 am

  #1979430

  Grant Fritchey - Monday, February 5, 2018 1:11 PM

  Get a copy of SentryOne Plan Explorer. It's free. Anonymize the plans (it'll clean the query & everything) and then post those. Otherwise, everything everyone is saying is just random stabs in the dark. You can't get good assistance without providing us with information. With no information, it could be anything.

  Ok - got it - I had to delete a load of fields from the select statement before it let me anonylize. Is this whats needed?

  <?xml version="1.0" encoding="utf-16"?>
  <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1.1" Build="10.0.5538.0">
  <BatchSequence>
    <Batch>
    <Statements>
     <StmtSimple StatementText="SELECT  Object1.Column1 AS Column2, Object1.Column3 AS Column4, Object2.Column5, Object3.Column6, Object2.Column7, Object2.Column8, Object2.Column9, Object2.Column10, Object2.Column11 AS Column12, Object2.Column13 AS Column14, Object2.Column15 AS Column16, Object2.Column17, Object2.Column18, Object2.Column19, Object2.Column20, Object2.Column21, Object4.Column22, Object2.Column23, Object2.Column24, Object2.Column25, Object5.Column26, Function1(Object5.Column27, ?) + ? + Function1(Object5.Column28, ?) + ? + Function1(Object5.Column29, ?) + ? + Function1(Object5.Column30, ?) + ? + Function1(Object5.Column31, ?) AS Column32, Object5.Column31, Object3.Column33, Object3.Column34, Object3.Column35, Object3.Column36, Object6.Column37, Object6.Column38, Object6.Column39 AS Column40, Object6.Column41, Object6.Column42, Object6.Column43, Object7.Column44, Object7.Column45, Object6.Column46, Object7.Column47, Object8.Column48 AS Column49, Object8.Column50 AS Column51, CAST(Object2.Column52 AS Varchar(MAX)) AS Column53, Object2.Column54 AS Column55, Object5.Column56, Object3.Column57 AS Column58, Object2.Column59, Object7.Column60, Object7.Column44 AS Column61, Object2.Column5 AS Column62, Object3.Column6 AS Column63, Object6.Column46 AS Column64, Object3.Column65, Object9.Column66 AS Column67, Object2.Column66, Object6.Column68 AS Column69, Object10.Column43 AS Column70, Object11.Column71 AS Column72, Object11.Column50 AS Column73, Object11.Column74, Object12.Column75 AS Column76 FROM   Object11 INNER JOIN Object2 INNER JOIN Object3 ON Object2.Column5 = Object3.Column77 INNER JOIN Object5 ON Object3.Column78 = Object5.Column56 INNER JOIN Object7 ON Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 AND Object3.Column6 = Object7.Column60 INNER JOIN        Object6 ON Object7.Column78 = Object6.Column46 ON Object11.Column48 = Object7.Column47 LEFT OUTER JOIN Object12 ON Object3.Column6 = Object12.Column78 LEFT OUTER JOIN Object10 LEFT OUTER JOIN Object13 ON Object10.Column79 = Object13.Column80 ON Object6.Column43 = Object10.Column79 LEFT OUTER JOIN        Object14 ON Object7.Column47 = Object14.Column78 LEFT OUTER JOIN Object15 ON Object14.Column81 = Object15.Column78 LEFT OUTER JOIN Object4 ON Object2.Column21 = Object4.Column71 LEFT OUTER JOIN Object1 ON Object2.Column9 = Object1.Column82 LEFT OUTER JOIN        Object8 ON Object2.Column5 = Object8.Column71 LEFT OUTER JOIN Object16 ON Object2.Column83 = Object16.Column84 FULL OUTER JOIN Object9 ON Object6.Column46 = Object9.Column85 AND Object2.Column5 = Object9.Column78 WHERE  (Object3.Column34 = ?) AND (Object3.Column65 = ?) AND (Object7.Column45 &lt;&gt; ?) AND (Object7.Column44 BETWEEN Object3.Column35 - ? AND Object3.Column35 + ?) AND (Object11.Column74 &lt;&gt; ?) AND (Object11.Column86 = ?) AND        (Object3.Column35 between ? AND ?) AND        (Object2.Column7 Like ?) AND (Object1.Column1 Like ?+?) AND ( Object1.Column3 Like ?+?) ORDER BY Object3.Column35,Column62, Column63, Column64" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="823.7" StatementEstRows="43885.6" StatementOptmLevel="FULL" QueryHash="0xDD08982D92A2496A" QueryPlanHash="0x482EBFF205026062">
      <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
      <QueryPlan DegreeOfParallelism="0" MemoryGrant="257664" CachedPlanSize="896" CompileTime="909" CompileCPU="904" CompileMemory="17488">
      <RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="0.183442" AvgRowSize="8364" EstimatedTotalSubtreeCost="823.7" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
       <OutputList>
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object9" Column="Column66" />
        <ColumnReference Column="Expr1057" />
        <ColumnReference Column="Expr1058" />
       </OutputList>
       <RunTimeInformation>
        <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualEndOfScans="1" ActualExecutions="1" />
       </RunTimeInformation>
       <NestedLoops Optimized="0" WithOrderedPrefetch="1">
        <OuterReferences>
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
        <ColumnReference Column="Expr1072" />
        </OuterReferences>
        <RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="43885.6" EstimateIO="494.212" EstimateCPU="3.10653" AvgRowSize="8356" EstimatedTotalSubtreeCost="777.024" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
        <OutputList>
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
         <ColumnReference Column="Expr1057" />
         <ColumnReference Column="Expr1058" />
        </OutputList>
        <MemoryFractions Input="0.234284" Output="1" />
        <RunTimeInformation>
         <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
        </RunTimeInformation>
        <Sort Distinct="0">
         <OrderBy>
          <OrderByColumn Ascending="1">
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
          </OrderByColumn>
          <OrderByColumn Ascending="1">
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
          </OrderByColumn>
          <OrderByColumn Ascending="1">
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
          </OrderByColumn>
          <OrderByColumn Ascending="1">
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
          </OrderByColumn>
         </OrderBy>
         <RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="0.512345" AvgRowSize="8356" EstimatedTotalSubtreeCost="279.706" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
          <OutputList>
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
          <ColumnReference Column="Expr1057" />
          <ColumnReference Column="Expr1058" />
          </OutputList>
          <MemoryFractions Input="0.00716132" Output="0.00548354" />
          <RunTimeInformation>
          <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualEndOfScans="1" ActualExecutions="1" />
          </RunTimeInformation>
          <Hash>
          <DefinedValues />
          <HashKeysBuild>
           <ColumnReference Database="Database1" Schema="Schema1" Table="Object16" Column="Column84" />
          </HashKeysBuild>
          <HashKeysProbe>
           <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
          </HashKeysProbe>
          <ProbeResidual>
           <ScalarOperator ScalarString="ScalarString1">
            <Compare CompareOp="EQ">
            <ScalarOperator>
             <Identifier>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
             </Identifier>
            </ScalarOperator>
            <ScalarOperator>
             <Identifier>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object16" Column="Column84" />
             </Identifier>
            </ScalarOperator>
            </Compare>
           </ScalarOperator>
          </ProbeResidual>
          <RelOp NodeId="4" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6475" EstimateIO="0.386088" EstimateCPU="0.0072795" AvgRowSize="24" EstimatedTotalSubtreeCost="0.393367" TableCardinality="6475" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
           <OutputList>
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object16" Column="Column84" />
           </OutputList>
           <RunTimeInformation>
            <RunTimeCountersPerThread Thread="0" ActualRows="6475" ActualEndOfScans="1" ActualExecutions="1" />
           </RunTimeInformation>
           <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
            <DefinedValues>
            <DefinedValue>
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object16" Column="Column84" />
            </DefinedValue>
            </DefinedValues>
            <Object Database="Database1" Schema="Schema1" Table="Object16" IndexKind="Heap" />
           </TableScan>
          </RelOp>
          <RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="17.5635" AvgRowSize="8372" EstimatedTotalSubtreeCost="278.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
           <OutputList>
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
            <ColumnReference Column="Expr1057" />
            <ColumnReference Column="Expr1058" />
           </OutputList>
           <MemoryFractions Input="0.0840584" Output="0.0643649" />
           <RunTimeInformation>
            <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualEndOfScans="1" ActualExecutions="1" />
           </RunTimeInformation>
           <Hash>
            <DefinedValues />
            <HashKeysBuild>
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column71" />
            </HashKeysBuild>
            <HashKeysProbe>
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
            </HashKeysProbe>
            <ProbeResidual>
            <ScalarOperator ScalarString="ScalarString2">
             <Compare CompareOp="EQ">
              <ScalarOperator>
              <Identifier>
               <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
              </Identifier>
              </ScalarOperator>
              <ScalarOperator>
              <Identifier>
               <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column71" />
              </Identifier>
              </ScalarOperator>
             </Compare>
            </ScalarOperator>
            </ProbeResidual>
            <RelOp NodeId="6" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="151906" EstimateIO="3.18312" EstimateCPU="0.167254" AvgRowSize="137" EstimatedTotalSubtreeCost="3.35038" TableCardinality="151906" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
            <OutputList>
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column71" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
            </OutputList>
            <RunTimeInformation>
             <RunTimeCountersPerThread Thread="0" ActualRows="151906" ActualEndOfScans="1" ActualExecutions="1" />
            </RunTimeInformation>
            <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
             <DefinedValues>
              <DefinedValue>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column71" />
              </DefinedValue>
              <DefinedValue>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column50" />
              </DefinedValue>
              <DefinedValue>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object8" Column="Column48" />
              </DefinedValue>
             </DefinedValues>
             <Object Database="Database1" Schema="Schema1" Table="Object8" Index="Index1" IndexKind="Clustered" />
            </IndexScan>
            </RelOp>
            <RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="0.365475" AvgRowSize="8268" EstimatedTotalSubtreeCost="257.886" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
            <OutputList>
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
             <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
             <ColumnReference Column="Expr1057" />
             <ColumnReference Column="Expr1058" />
            </OutputList>
            <MemoryFractions Input="0.000778168" Output="0.000595856" />
            <RunTimeInformation>
             <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualEndOfScans="1" ActualExecutions="1" />
            </RunTimeInformation>
            <Hash>
             <DefinedValues />
             <HashKeysBuild>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column71" />
             </HashKeysBuild>
             <HashKeysProbe>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
             </HashKeysProbe>
             <ProbeResidual>
              <ScalarOperator ScalarString="ScalarString3">
              <Compare CompareOp="EQ">
               <ScalarOperator>
                <Identifier>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                </Identifier>
               </ScalarOperator>
               <ScalarOperator>
                <Identifier>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column71" />
                </Identifier>
               </ScalarOperator>
              </Compare>
              </ScalarOperator>
             </ProbeResidual>
             <RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="279" EstimateIO="0.0068287" EstimateCPU="0.0004639" AvgRowSize="65" EstimatedTotalSubtreeCost="0.0072926" TableCardinality="279" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column71" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
              </OutputList>
              <RunTimeInformation>
              <RunTimeCountersPerThread Thread="0" ActualRows="279" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
              <DefinedValues>
               <DefinedValue>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column71" />
               </DefinedValue>
               <DefinedValue>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Column="Column22" />
               </DefinedValue>
              </DefinedValues>
              <Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" IndexKind="Clustered" />
              </IndexScan>
             </RelOp>
             <RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="1.20794" AvgRowSize="8268" EstimatedTotalSubtreeCost="257.514" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
              <ColumnReference Column="Expr1057" />
              <ColumnReference Column="Expr1058" />
              </OutputList>
              <MemoryFractions Input="0.0165429" Output="0.0126671" />
              <RunTimeInformation>
              <RunTimeCountersPerThread Thread="0" ActualRows="67020" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Hash>
              <DefinedValues />
              <HashKeysBuild>
               <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column78" />
              </HashKeysBuild>
              <HashKeysProbe>
               <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
              </HashKeysProbe>
              <ProbeResidual>
               <ScalarOperator ScalarString="ScalarString4">
                <Compare CompareOp="EQ">
                <ScalarOperator>
                 <Identifier>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                 </Identifier>
                </ScalarOperator>
                <ScalarOperator>
                 <Identifier>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column78" />
                 </Identifier>
                </ScalarOperator>
                </Compare>
               </ScalarOperator>
              </ProbeResidual>
              <RelOp NodeId="10" PhysicalOp="Merge Join" LogicalOp="Left Outer Join" EstimateRows="18531" EstimateIO="0" EstimateCPU="0.0541865" AvgRowSize="35" EstimatedTotalSubtreeCost="0.460304" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
               <OutputList>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column78" />
               </OutputList>
               <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="18534" ActualEndOfScans="1" ActualExecutions="1" />
               </RunTimeInformation>
               <Merge ManyToMany="0">
                <InnerSideJoinColumns>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                </InnerSideJoinColumns>
                <OuterSideJoinColumns>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column81" />
                </OuterSideJoinColumns>
                <Residual>
                <ScalarOperator ScalarString="ScalarString5">
                 <Compare CompareOp="EQ">
                  <ScalarOperator>
                  <Identifier>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column81" />
                  </Identifier>
                  </ScalarOperator>
                  <ScalarOperator>
                  <Identifier>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                  </Identifier>
                  </ScalarOperator>
                 </Compare>
                </ScalarOperator>
                </Residual>
                <RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="18531" EstimateIO="0.250532" EstimateCPU="0.0205411" AvgRowSize="59" EstimatedTotalSubtreeCost="0.271074" TableCardinality="18531" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                <OutputList>
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column81" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column78" />
                </OutputList>
                <RunTimeInformation>
                 <RunTimeCountersPerThread Thread="0" ActualRows="18531" ActualEndOfScans="1" ActualExecutions="1" />
                </RunTimeInformation>
                <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                 <DefinedValues>
                  <DefinedValue>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column81" />
                  </DefinedValue>
                  <DefinedValue>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Column="Column78" />
                  </DefinedValue>
                 </DefinedValues>
                 <Object Database="Database1" Schema="Schema1" Table="Object14" Index="Index3" IndexKind="Clustered" />
                </IndexScan>
                </RelOp>
                <RelOp NodeId="12" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="3723" EstimateIO="0.0112613" EstimateCPU="0.0689946" AvgRowSize="32" EstimatedTotalSubtreeCost="0.135041" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                <OutputList>
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                </OutputList>
                <MemoryFractions Input="0.891459" Output="0.891459" />
                <RunTimeInformation>
                 <RunTimeCountersPerThread Thread="0" ActualRows="3723" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
                </RunTimeInformation>
                <Sort Distinct="0">
                 <OrderBy>
                  <OrderByColumn Ascending="1">
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                  </OrderByColumn>
                 </OrderBy>
                 <RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3723" EstimateIO="0.0505324" EstimateCPU="0.0042523" AvgRowSize="32" EstimatedTotalSubtreeCost="0.0547847" TableCardinality="3723" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                  </OutputList>
                  <RunTimeInformation>
                  <RunTimeCountersPerThread Thread="0" ActualRows="3723" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                  <DefinedValues>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object15" Column="Column78" />
                   </DefinedValue>
                  </DefinedValues>
                  <Object Database="Database1" Schema="Schema1" Table="Object15" Index="Index4" IndexKind="Clustered" />
                  </IndexScan>
                 </RelOp>
                </Sort>
                </RelOp>
               </Merge>
              </RelOp>
              <RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="43885.6" EstimateIO="0" EstimateCPU="0.43596" AvgRowSize="8268" EstimatedTotalSubtreeCost="255.845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
               <OutputList>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                <ColumnReference Column="Expr1057" />
                <ColumnReference Column="Expr1058" />
               </OutputList>
               <MemoryFractions Input="0.00166517" Output="0.00127505" />
               <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="66941" ActualEndOfScans="1" ActualExecutions="1" />
               </RunTimeInformation>
               <Hash>
                <DefinedValues />
                <HashKeysBuild>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                </HashKeysBuild>
                <HashKeysProbe>
                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                </HashKeysProbe>
                <ProbeResidual>
                <ScalarOperator ScalarString="ScalarString6">
                 <Compare CompareOp="EQ">
                  <ScalarOperator>
                  <Identifier>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                  </Identifier>
                  </ScalarOperator>
                  <ScalarOperator>
                  <Identifier>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                  </Identifier>
                  </ScalarOperator>
                 </Compare>
                </ScalarOperator>
                </ProbeResidual>
                <RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="262" EstimateIO="0" EstimateCPU="0.0211799" AvgRowSize="274" EstimatedTotalSubtreeCost="0.0302915" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                <OutputList>
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
                </OutputList>
                <MemoryFractions Input="0" Output="0" />
                <RunTimeInformation>
                 <RunTimeCountersPerThread Thread="0" ActualRows="262" ActualEndOfScans="1" ActualExecutions="1" />
                </RunTimeInformation>
                <Hash>
                 <DefinedValues />
                 <HashKeysBuild>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Column="Column80" />
                 </HashKeysBuild>
                 <HashKeysProbe>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                 </HashKeysProbe>
                 <ProbeResidual>
                  <ScalarOperator ScalarString="ScalarString7">
                  <Compare CompareOp="EQ">
                   <ScalarOperator>
                    <Identifier>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                    </Identifier>
                   </ScalarOperator>
                   <ScalarOperator>
                    <Identifier>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Column="Column80" />
                    </Identifier>
                   </ScalarOperator>
                  </Compare>
                  </ScalarOperator>
                 </ProbeResidual>
                 <RelOp NodeId="17" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="31" EstimateIO="0.00386574" EstimateCPU="0.0001911" AvgRowSize="17" EstimatedTotalSubtreeCost="0.00405684" TableCardinality="31" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Column="Column80" />
                  </OutputList>
                  <RunTimeInformation>
                  <RunTimeCountersPerThread Thread="0" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                  <DefinedValues>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Column="Column80" />
                   </DefinedValue>
                  </DefinedValues>
                  <Object Database="Database1" Schema="Schema1" Table="Object13" IndexKind="Heap" />
                  </TableScan>
                 </RelOp>
                 <RelOp NodeId="18" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="262" EstimateIO="0.00460648" EstimateCPU="0.0004452" AvgRowSize="274" EstimatedTotalSubtreeCost="0.00505168" TableCardinality="262" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
                  </OutputList>
                  <RunTimeInformation>
                  <RunTimeCountersPerThread Thread="0" ActualRows="262" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                  <DefinedValues>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column79" />
                   </DefinedValue>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Column="Column43" />
                   </DefinedValue>
                  </DefinedValues>
                  <Object Database="Database1" Schema="Schema1" Table="Object10" IndexKind="Heap" />
                  </TableScan>
                 </RelOp>
                </Hash>
                </RelOp>
                <RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="42350.2" EstimateIO="0" EstimateCPU="14.4252" AvgRowSize="8011" EstimatedTotalSubtreeCost="255.379" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                <OutputList>
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                 <ColumnReference Column="Expr1057" />
                 <ColumnReference Column="Expr1058" />
                </OutputList>
                <MemoryFractions Input="0.0904089" Output="0.0692276" />
                <RunTimeInformation>
                 <RunTimeCountersPerThread Thread="0" ActualRows="66941" ActualEndOfScans="1" ActualExecutions="1" />
                </RunTimeInformation>
                <Hash>
                 <DefinedValues />
                 <HashKeysBuild>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column78" />
                 </HashKeysBuild>
                 <HashKeysProbe>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                 </HashKeysProbe>
                 <ProbeResidual>
                  <ScalarOperator ScalarString="ScalarString8">
                  <Compare CompareOp="EQ">
                   <ScalarOperator>
                    <Identifier>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                    </Identifier>
                   </ScalarOperator>
                   <ScalarOperator>
                    <Identifier>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column78" />
                    </Identifier>
                   </ScalarOperator>
                  </Compare>
                  </ScalarOperator>
                 </ProbeResidual>
                 <RelOp NodeId="21" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="236371" EstimateIO="32.2794" EstimateCPU="0.260165" AvgRowSize="84" EstimatedTotalSubtreeCost="32.5396" TableCardinality="236371" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column78" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
                  </OutputList>
                  <RunTimeInformation>
                  <RunTimeCountersPerThread Thread="0" ActualRows="236371" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                  <DefinedValues>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column78" />
                   </DefinedValue>
                   <DefinedValue>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Column="Column75" />
                   </DefinedValue>
                  </DefinedValues>
                  <Object Database="Database1" Schema="Schema1" Table="Object12" IndexKind="Heap" />
                  </TableScan>
                 </RelOp>
                 <RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="42350.2" EstimateIO="0" EstimateCPU="0.412143" AvgRowSize="7959" EstimatedTotalSubtreeCost="208.414" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                  <ColumnReference Column="Expr1057" />
                  <ColumnReference Column="Expr1058" />
                  </OutputList>
                  <MemoryFractions Input="0.00127881" Output="0.000979203" />
                  <RunTimeInformation>
                  <RunTimeCountersPerThread Thread="0" ActualRows="66836" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <Hash>
                  <DefinedValues />
                  <HashKeysBuild>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column82" />
                  </HashKeysBuild>
                  <HashKeysProbe>
                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                  </HashKeysProbe>
                  <ProbeResidual>
                   <ScalarOperator ScalarString="ScalarString9">
                    <Compare CompareOp="EQ">
                    <ScalarOperator>
                     <Identifier>
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                     </Identifier>
                    </ScalarOperator>
                    <ScalarOperator>
                     <Identifier>
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column82" />
                     </Identifier>
                    </ScalarOperator>
                    </Compare>
                   </ScalarOperator>
                  </ProbeResidual>
                  <RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="287" EstimateIO="0.0105324" EstimateCPU="0.0004727" AvgRowSize="138" EstimatedTotalSubtreeCost="0.0110051" TableCardinality="287" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                   <OutputList>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column82" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                   </OutputList>
                   <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="287" ActualEndOfScans="1" ActualExecutions="1" />
                   </RunTimeInformation>
                   <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                    <DefinedValues>
                    <DefinedValue>
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                    </DefinedValue>
                    <DefinedValue>
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column82" />
                    </DefinedValue>
                    <DefinedValue>
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                    </DefinedValue>
                    </DefinedValues>
                    <Object Database="Database1" Schema="Schema1" Table="Object1" Index="Index5" IndexKind="Clustered" />
                    <Predicate>
                    <ScalarOperator ScalarString="ScalarString10">
                     <Logical Operation="AND">
                      <ScalarOperator>
                      <Intrinsic FunctionName="Function2">
                       <ScalarOperator>
                        <Identifier>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column1" />
                        </Identifier>
                       </ScalarOperator>
                       <ScalarOperator>
                        <Const ConstValue="Value1" />
                       </ScalarOperator>
                      </Intrinsic>
                      </ScalarOperator>
                      <ScalarOperator>
                      <Intrinsic FunctionName="Function2">
                       <ScalarOperator>
                        <Identifier>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Column="Column3" />
                        </Identifier>
                       </ScalarOperator>
                       <ScalarOperator>
                        <Const ConstValue="Value1" />
                       </ScalarOperator>
                      </Intrinsic>
                      </ScalarOperator>
                     </Logical>
                    </ScalarOperator>
                    </Predicate>
                   </IndexScan>
                  </RelOp>
                  <RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="45329.8" EstimateIO="0" EstimateCPU="0.00401988" AvgRowSize="7870" EstimatedTotalSubtreeCost="207.991" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                   <OutputList>
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                    <ColumnReference Column="Expr1057" />
                    <ColumnReference Column="Expr1058" />
                   </OutputList>
                   <ComputeScalar>
                    <DefinedValues>
                    <DefinedValue>
                     <ColumnReference Column="Expr1057" />
                     <ScalarOperator ScalarString="ScalarString11">
                      <Arithmetic Operation="ADD">
                      <ScalarOperator>
                       <Arithmetic Operation="ADD">
                        <ScalarOperator>
                        <Arithmetic Operation="ADD">
                         <ScalarOperator>
                          <Arithmetic Operation="ADD">
                          <ScalarOperator>
                           <Arithmetic Operation="ADD">
                            <ScalarOperator>
                            <Arithmetic Operation="ADD">
                             <ScalarOperator>
                              <Arithmetic Operation="ADD">
                              <ScalarOperator>
                               <Arithmetic Operation="ADD">
                                <ScalarOperator>
                                <Intrinsic FunctionName="Function1">
                                 <ScalarOperator>
                                  <Identifier>
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column27" />
                                  </Identifier>
                                 </ScalarOperator>
                                 <ScalarOperator>
                                  <Const ConstValue="Value2" />
                                 </ScalarOperator>
                                </Intrinsic>
                                </ScalarOperator>
                                <ScalarOperator>
                                <Const ConstValue="Value2" />
                                </ScalarOperator>
                               </Arithmetic>
                              </ScalarOperator>
                              <ScalarOperator>
                               <Intrinsic FunctionName="Function1">
                                <ScalarOperator>
                                <Identifier>
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column28" />
                                </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                <Const ConstValue="Value2" />
                                </ScalarOperator>
                               </Intrinsic>
                              </ScalarOperator>
                              </Arithmetic>
                             </ScalarOperator>
                             <ScalarOperator>
                              <Const ConstValue="Value2" />
                             </ScalarOperator>
                            </Arithmetic>
                            </ScalarOperator>
                            <ScalarOperator>
                            <Intrinsic FunctionName="Function1">
                             <ScalarOperator>
                              <Identifier>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column29" />
                              </Identifier>
                             </ScalarOperator>
                             <ScalarOperator>
                              <Const ConstValue="Value2" />
                             </ScalarOperator>
                            </Intrinsic>
                            </ScalarOperator>
                           </Arithmetic>
                          </ScalarOperator>
                          <ScalarOperator>
                           <Const ConstValue="Value2" />
                          </ScalarOperator>
                          </Arithmetic>
                         </ScalarOperator>
                         <ScalarOperator>
                          <Intrinsic FunctionName="Function1">
                          <ScalarOperator>
                           <Identifier>
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column30" />
                           </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                           <Const ConstValue="Value3" />
                          </ScalarOperator>
                          </Intrinsic>
                         </ScalarOperator>
                        </Arithmetic>
                        </ScalarOperator>
                        <ScalarOperator>
                        <Const ConstValue="Value2" />
                        </ScalarOperator>
                       </Arithmetic>
                      </ScalarOperator>
                      <ScalarOperator>
                       <Intrinsic FunctionName="Function1">
                        <ScalarOperator>
                        <Identifier>
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                        </Identifier>
                        </ScalarOperator>
                        <ScalarOperator>
                        <Const ConstValue="Value2" />
                        </ScalarOperator>
                       </Intrinsic>
                      </ScalarOperator>
                      </Arithmetic>
                     </ScalarOperator>
                    </DefinedValue>
                    </DefinedValues>
                    <RelOp NodeId="25" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="40198.8" EstimateIO="0" EstimateCPU="0.168031" AvgRowSize="7823" EstimatedTotalSubtreeCost="207.987" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                    <OutputList>
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column27" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column28" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column29" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column30" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                     <ColumnReference Column="Expr1058" />
                    </OutputList>
                    <RunTimeInformation>
                     <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="1" ActualExecutions="1" />
                    </RunTimeInformation>
                    <NestedLoops Optimized="1" WithUnorderedPrefetch="1">
                     <OuterReferences>
                      <ColumnReference Column="Column87" />
                      <ColumnReference Column="Expr1071" />
                     </OuterReferences>
                     <RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="40198.8" EstimateIO="0" EstimateCPU="0.219766" AvgRowSize="7518" EstimatedTotalSubtreeCost="199.212" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                      <OutputList>
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                      <ColumnReference Column="Column87" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                      <ColumnReference Column="Expr1058" />
                      <ColumnReference Column="Expr1070" />
                      </OutputList>
                      <ComputeScalar>
                      <DefinedValues>
                       <DefinedValue>
                        <ColumnReference Column="Expr1070" />
                        <ScalarOperator ScalarString="ScalarString12">
                        <Intrinsic FunctionName="Function3">
                         <ScalarOperator>
                          <Identifier>
                          <ColumnReference Column="Column87" />
                          </Identifier>
                         </ScalarOperator>
                        </Intrinsic>
                        </ScalarOperator>
                       </DefinedValue>
                      </DefinedValues>
                      <RelOp NodeId="29" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="40198.8" EstimateIO="0" EstimateCPU="0.219766" AvgRowSize="7518" EstimatedTotalSubtreeCost="199.212" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                       <OutputList>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                        <ColumnReference Column="Column87" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                        <ColumnReference Column="Expr1058" />
                       </OutputList>
                       <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="1" ActualExecutions="1" />
                       </RunTimeInformation>
                       <NestedLoops Optimized="0" WithUnorderedPrefetch="1">
                        <OuterReferences>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                        <ColumnReference Column="Expr1069" />
                        </OuterReferences>
                        <RelOp NodeId="31" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="52575.5" EstimateIO="0" EstimateCPU="0.00423433" AvgRowSize="7510" EstimatedTotalSubtreeCost="184.839" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                        <OutputList>
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                         <ColumnReference Column="Expr1058" />
                        </OutputList>
                        <ComputeScalar>
                         <DefinedValues>
                          <DefinedValue>
                          <ColumnReference Column="Expr1058" />
                          <ScalarOperator ScalarString="ScalarString13">
                           <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="0">
                            <ScalarOperator>
                            <Identifier>
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column52" />
                            </Identifier>
                            </ScalarOperator>
                           </Convert>
                          </ScalarOperator>
                          </DefinedValue>
                         </DefinedValues>
                         <RelOp NodeId="32" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="42343.3" EstimateIO="0.0112613" EstimateCPU="2.98732" AvgRowSize="3550" EstimatedTotalSubtreeCost="184.835" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                          <OutputList>
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column52" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                          </OutputList>
                          <MemoryFractions Input="0.184723" Output="0.417941" />
                          <RunTimeInformation>
                          <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <Sort Distinct="0">
                          <OrderBy>
                           <OrderByColumn Ascending="1">
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                           </OrderByColumn>
                          </OrderBy>
                          <RelOp NodeId="33" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="42375" EstimateIO="0" EstimateCPU="0.177128" AvgRowSize="3550" EstimatedTotalSubtreeCost="181.799" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                           <OutputList>
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column52" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                           </OutputList>
                           <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="1" ActualExecutions="1" />
                           </RunTimeInformation>
                           <NestedLoops Optimized="1" WithUnorderedPrefetch="1">
                            <OuterReferences>
                            <ColumnReference Column="Column88" />
                            <ColumnReference Column="Expr1068" />
                            </OuterReferences>
                            <RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="42375" EstimateIO="0" EstimateCPU="0.265577" AvgRowSize="1133" EstimatedTotalSubtreeCost="172.033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                            <OutputList>
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                             <ColumnReference Column="Column88" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                             <ColumnReference Column="Expr1067" />
                            </OutputList>
                            <ComputeScalar>
                             <DefinedValues>
                              <DefinedValue>
                              <ColumnReference Column="Expr1067" />
                              <ScalarOperator ScalarString="ScalarString14">
                               <Intrinsic FunctionName="Function3">
                                <ScalarOperator>
                                <Identifier>
                                 <ColumnReference Column="Column88" />
                                </Identifier>
                                </ScalarOperator>
                               </Intrinsic>
                              </ScalarOperator>
                              </DefinedValue>
                             </DefinedValues>
                             <RelOp NodeId="37" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="42375" EstimateIO="0" EstimateCPU="0.265577" AvgRowSize="1133" EstimatedTotalSubtreeCost="172.033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                              <OutputList>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                              <ColumnReference Column="Column88" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                              </OutputList>
                              <RunTimeInformation>
                              <RunTimeCountersPerThread Thread="0" ActualRows="61214" ActualEndOfScans="1" ActualExecutions="1" />
                              </RunTimeInformation>
                              <NestedLoops Optimized="1" WithUnorderedPrefetch="1">
                              <OuterReferences>
                               <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                               <ColumnReference Column="Expr1066" />
                              </OuterReferences>
                              <RelOp NodeId="40" PhysicalOp="Merge Join" LogicalOp="Inner Join" EstimateRows="63535.3" EstimateIO="0" EstimateCPU="0.265257" AvgRowSize="1126" EstimatedTotalSubtreeCost="156.925" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                               <OutputList>
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                               </OutputList>
                               <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="61214" ActualEndOfScans="1" ActualExecutions="1" />
                               </RunTimeInformation>
                               <Merge ManyToMany="0">
                                <InnerSideJoinColumns>
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                </InnerSideJoinColumns>
                                <OuterSideJoinColumns>
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                </OuterSideJoinColumns>
                                <Residual>
                                <ScalarOperator ScalarString="ScalarString15">
                                 <Logical Operation="AND">
                                  <ScalarOperator>
                                  <Compare CompareOp="EQ">
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                    </Identifier>
                                   </ScalarOperator>
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                    </Identifier>
                                   </ScalarOperator>
                                  </Compare>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                  <Compare CompareOp="GE">
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                    </Identifier>
                                   </ScalarOperator>
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Column="Expr1059" />
                                    </Identifier>
                                   </ScalarOperator>
                                  </Compare>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                  <Compare CompareOp="LE">
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                    </Identifier>
                                   </ScalarOperator>
                                   <ScalarOperator>
                                    <Identifier>
                                    <ColumnReference Column="Expr1060" />
                                    </Identifier>
                                   </ScalarOperator>
                                  </Compare>
                                  </ScalarOperator>
                                 </Logical>
                                </ScalarOperator>
                                </Residual>
                                <RelOp NodeId="41" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="44085.3" EstimateIO="0.0112613" EstimateCPU="3.12198" AvgRowSize="391" EstimatedTotalSubtreeCost="15.8841" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                <OutputList>
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                                 <ColumnReference Column="Expr1059" />
                                 <ColumnReference Column="Expr1060" />
                                </OutputList>
                                <MemoryFractions Input="0.798106" Output="0.269449" />
                                <RunTimeInformation>
                                 <RunTimeCountersPerThread Thread="0" ActualRows="34169" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
                                </RunTimeInformation>
                                <Sort Distinct="0">
                                 <OrderBy>
                                  <OrderByColumn Ascending="1">
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                  </OrderByColumn>
                                 </OrderBy>
                                 <RelOp NodeId="42" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="44085.3" EstimateIO="0" EstimateCPU="0.0514696" AvgRowSize="391" EstimatedTotalSubtreeCost="11.9891" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                  <OutputList>
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                                  <ColumnReference Column="Expr1059" />
                                  <ColumnReference Column="Expr1060" />
                                  </OutputList>
                                  <ComputeScalar>
                                  <DefinedValues>
                                   <DefinedValue>
                                    <ColumnReference Column="Expr1059" />
                                    <ScalarOperator ScalarString="ScalarString16">
                                    <Arithmetic Operation="SUB">
                                     <ScalarOperator>
                                      <Identifier>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                      </Identifier>
                                     </ScalarOperator>
                                     <ScalarOperator>
                                      <Const ConstValue="Value4" />
                                     </ScalarOperator>
                                    </Arithmetic>
                                    </ScalarOperator>
                                   </DefinedValue>
                                   <DefinedValue>
                                    <ColumnReference Column="Expr1060" />
                                    <ScalarOperator ScalarString="ScalarString17">
                                    <Arithmetic Operation="ADD">
                                     <ScalarOperator>
                                      <Identifier>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                      </Identifier>
                                     </ScalarOperator>
                                     <ScalarOperator>
                                      <Const ConstValue="Value4" />
                                     </ScalarOperator>
                                    </Arithmetic>
                                    </ScalarOperator>
                                   </DefinedValue>
                                  </DefinedValues>
                                  <RelOp NodeId="43" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="44085.3" EstimateIO="11.3713" EstimateCPU="0.566323" AvgRowSize="375" EstimatedTotalSubtreeCost="11.9376" TableCardinality="514696" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                   <OutputList>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                                   </OutputList>
                                   <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="34169" ActualEndOfScans="1" ActualExecutions="1" />
                                   </RunTimeInformation>
                                   <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                    <DefinedValues>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column6" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column33" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column57" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column36" />
                                    </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="Database1" Schema="Schema1" Table="Object3" IndexKind="Heap" />
                                    <Predicate>
                                    <ScalarOperator ScalarString="ScalarString18">
                                     <Logical Operation="AND">
                                      <ScalarOperator>
                                      <Compare CompareOp="EQ">
                                       <ScalarOperator>
                                        <Identifier>
                                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column65" />
                                        </Identifier>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Const ConstValue="Value5" />
                                       </ScalarOperator>
                                      </Compare>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                      <Compare CompareOp="GE">
                                       <ScalarOperator>
                                        <Identifier>
                                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                        </Identifier>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Const ConstValue="Value6" />
                                       </ScalarOperator>
                                      </Compare>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                      <Compare CompareOp="LE">
                                       <ScalarOperator>
                                        <Identifier>
                                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column35" />
                                        </Identifier>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Const ConstValue="Value7" />
                                       </ScalarOperator>
                                      </Compare>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                      <Compare CompareOp="EQ">
                                       <ScalarOperator>
                                        <Identifier>
                                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column34" />
                                        </Identifier>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Const ConstValue="Value8" />
                                       </ScalarOperator>
                                      </Compare>
                                      </ScalarOperator>
                                     </Logical>
                                    </ScalarOperator>
                                    </Predicate>
                                   </TableScan>
                                  </RelOp>
                                  </ComputeScalar>
                                 </RelOp>
                                </Sort>
                                </RelOp>
                                <RelOp NodeId="49" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="76535.3" EstimateIO="0.0112613" EstimateCPU="5.69949" AvgRowSize="759" EstimatedTotalSubtreeCost="140.775" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                <OutputList>
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                                </OutputList>
                                <MemoryFractions Input="0.0742789" Output="0.193611" />
                                <RunTimeInformation>
                                 <RunTimeCountersPerThread Thread="0" ActualRows="64261" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="1" />
                                </RunTimeInformation>
                                <Sort Distinct="0">
                                 <OrderBy>
                                  <OrderByColumn Ascending="1">
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                  </OrderByColumn>
                                 </OrderBy>
                                 <RelOp NodeId="50" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="76535.3" EstimateIO="0" EstimateCPU="36.0324" AvgRowSize="759" EstimatedTotalSubtreeCost="135.065" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                  <OutputList>
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                                  <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                                  </OutputList>
                                  <MemoryFractions Input="0.125025" Output="0.119332" />
                                  <RunTimeInformation>
                                  <RunTimeCountersPerThread Thread="0" ActualRows="68309" ActualEndOfScans="1" ActualExecutions="1" />
                                  </RunTimeInformation>
                                  <Hash>
                                  <DefinedValues />
                                  <HashKeysBuild>
                                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                  </HashKeysBuild>
                                  <HashKeysProbe>
                                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                  </HashKeysProbe>
                                  <ProbeResidual>
                                   <ScalarOperator ScalarString="ScalarString19">
                                    <Compare CompareOp="EQ">
                                    <ScalarOperator>
                                     <Identifier>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                     </Identifier>
                                    </ScalarOperator>
                                    <ScalarOperator>
                                     <Identifier>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                     </Identifier>
                                    </ScalarOperator>
                                    </Compare>
                                   </ScalarOperator>
                                  </ProbeResidual>
                                  <RelOp NodeId="51" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="76535.3" EstimateIO="0" EstimateCPU="18.1588" AvgRowSize="216" EstimatedTotalSubtreeCost="54.5746" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                   <OutputList>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                   </OutputList>
                                   <MemoryFractions Input="0.193611" Output="0.0685857" />
                                   <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="68817" ActualEndOfScans="1" ActualExecutions="1" />
                                   </RunTimeInformation>
                                   <Hash>
                                    <DefinedValues />
                                    <HashKeysBuild>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column48" />
                                    </HashKeysBuild>
                                    <HashKeysProbe>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                    </HashKeysProbe>
                                    <ProbeResidual>
                                    <ScalarOperator ScalarString="ScalarString20">
                                     <Compare CompareOp="EQ">
                                      <ScalarOperator>
                                      <Identifier>
                                       <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                      </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                      <Identifier>
                                       <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column48" />
                                      </Identifier>
                                      </ScalarOperator>
                                     </Compare>
                                    </ScalarOperator>
                                    </ProbeResidual>
                                    <RelOp NodeId="52" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="76535.3" EstimateIO="4.48468" EstimateCPU="0.187489" AvgRowSize="157" EstimatedTotalSubtreeCost="4.67217" TableCardinality="170373" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                    <OutputList>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column48" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                    </OutputList>
                                    <RunTimeInformation>
                                     <RunTimeCountersPerThread Thread="0" ActualRows="73523" ActualEndOfScans="1" ActualExecutions="1" />
                                    </RunTimeInformation>
                                    <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                     <DefinedValues>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column71" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column50" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column48" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                      </DefinedValue>
                                     </DefinedValues>
                                     <Object Database="Database1" Schema="Schema1" Table="Object11" Index="Index6" IndexKind="Clustered" />
                                     <Predicate>
                                      <ScalarOperator ScalarString="ScalarString21">
                                      <Logical Operation="AND">
                                       <ScalarOperator>
                                        <Compare CompareOp="EQ">
                                        <ScalarOperator>
                                         <Identifier>
                                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column86" />
                                         </Identifier>
                                        </ScalarOperator>
                                        <ScalarOperator>
                                         <Const ConstValue="Value9" />
                                        </ScalarOperator>
                                        </Compare>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Compare CompareOp="NE">
                                        <ScalarOperator>
                                         <Identifier>
                                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Column="Column74" />
                                         </Identifier>
                                        </ScalarOperator>
                                        <ScalarOperator>
                                         <Const ConstValue="Value10" />
                                        </ScalarOperator>
                                        </Compare>
                                       </ScalarOperator>
                                      </Logical>
                                      </ScalarOperator>
                                     </Predicate>
                                    </IndexScan>
                                    </RelOp>
                                    <RelOp NodeId="53" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1.02723e+006" EstimateIO="29.8076" EstimateCPU="1.24357" AvgRowSize="104" EstimatedTotalSubtreeCost="31.0511" TableCardinality="1.13038e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                    <OutputList>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                    </OutputList>
                                    <RunTimeInformation>
                                     <RunTimeCountersPerThread Thread="0" ActualRows="1026723" ActualEndOfScans="1" ActualExecutions="1" />
                                    </RunTimeInformation>
                                    <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                     <DefinedValues>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column47" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column78" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column60" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                      </DefinedValue>
                                      <DefinedValue>
                                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column44" />
                                      </DefinedValue>
                                     </DefinedValues>
                                     <Object Database="Database1" Schema="Schema1" Table="Object7" IndexKind="Heap" />
                                     <Predicate>
                                      <ScalarOperator ScalarString="ScalarString22">
                                      <Compare CompareOp="NE">
                                       <ScalarOperator>
                                        <Identifier>
                                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object7" Column="Column45" />
                                        </Identifier>
                                       </ScalarOperator>
                                       <ScalarOperator>
                                        <Const ConstValue="Value11" />
                                       </ScalarOperator>
                                      </Compare>
                                      </ScalarOperator>
                                     </Predicate>
                                    </TableScan>
                                    </RelOp>
                                   </Hash>
                                  </RelOp>
                                  <RelOp NodeId="55" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1.12014e+006" EstimateIO="43.2253" EstimateCPU="1.23231" AvgRowSize="551" EstimatedTotalSubtreeCost="44.4577" TableCardinality="1.12014e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                   <OutputList>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                                   </OutputList>
                                   <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="1120141" ActualEndOfScans="1" ActualExecutions="1" />
                                   </RunTimeInformation>
                                   <TableScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                    <DefinedValues>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column37" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column38" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column41" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column42" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column43" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column39" />
                                    </DefinedValue>
                                    <DefinedValue>
                                     <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column68" />
                                    </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="Database1" Schema="Schema1" Table="Object6" IndexKind="Heap" />
                                   </TableScan>
                                  </RelOp>
                                  </Hash>
                                 </RelOp>
                                </Sort>
                                </RelOp>
                               </Merge>
                              </RelOp>
                              <RelOp NodeId="58" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="40" EstimatedTotalSubtreeCost="14.8422" TableCardinality="291185" Parallel="0" EstimateRebinds="63531.8" EstimateRewinds="2.47708">
                               <OutputList>
                                <ColumnReference Column="Column88" />
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                               </OutputList>
                               <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="61214" ActualEndOfScans="0" ActualExecutions="61214" />
                               </RunTimeInformation>
                               <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                <DefinedValues>
                                <DefinedValue>
                                 <ColumnReference Column="Column88" />
                                </DefinedValue>
                                <DefinedValue>
                                 <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                                </DefinedValue>
                                </DefinedValues>
                                <Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index7" IndexKind="NonClustered" />
                                <SeekPredicates>
                                <SeekPredicateNew>
                                 <SeekKeys>
                                  <Prefix ScanType="EQ">
                                  <RangeColumns>
                                   <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
                                  </RangeColumns>
                                  <RangeExpressions>
                                   <ScalarOperator ScalarString="ScalarString23">
                                    <Identifier>
                                    <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column77" />
                                    </Identifier>
                                   </ScalarOperator>
                                  </RangeExpressions>
                                  </Prefix>
                                 </SeekKeys>
                                </SeekPredicateNew>
                                </SeekPredicates>
                               </IndexScan>
                              </RelOp>
                              </NestedLoops>
                             </RelOp>
                            </ComputeScalar>
                            </RelOp>
                            <RelOp NodeId="63" PhysicalOp="RID Lookup" LogicalOp="RID Lookup" EstimateRows="42343.3" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="3137" EstimatedTotalSubtreeCost="9.58945" TableCardinality="291185" Parallel="0" EstimateRebinds="42347.8" EstimateRewinds="26.2904">
                            <OutputList>
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column52" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                             <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                            </OutputList>
                            <RunTimeInformation>
                             <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="14" ActualExecutions="61214" />
                            </RunTimeInformation>
                            <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                             <DefinedValues>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column8" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column10" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column9" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column54" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column19" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column20" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column21" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column17" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column18" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column59" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column23" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column24" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column25" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column52" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column83" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column66" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column11" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column13" />
                              </DefinedValue>
                              <DefinedValue>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column15" />
                              </DefinedValue>
                             </DefinedValues>
                             <Object Database="Database1" Schema="Schema1" Table="Object2" TableReferenceId="-1" IndexKind="Heap" />
                             <SeekPredicates>
                              <SeekPredicateNew>
                              <SeekKeys>
                               <Prefix ScanType="EQ">
                                <RangeColumns>
                                <ColumnReference Column="Column88" />
                                </RangeColumns>
                                <RangeExpressions>
                                <ScalarOperator ScalarString="ScalarString24">
                                 <Identifier>
                                  <ColumnReference Column="Column88" />
                                 </Identifier>
                                </ScalarOperator>
                                </RangeExpressions>
                               </Prefix>
                              </SeekKeys>
                              </SeekPredicateNew>
                             </SeekPredicates>
                             <Predicate>
                              <ScalarOperator ScalarString="ScalarString25">
                              <Intrinsic FunctionName="Function2">
                               <ScalarOperator>
                                <Identifier>
                                <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column7" />
                                </Identifier>
                               </ScalarOperator>
                               <ScalarOperator>
                                <Const ConstValue="Value12" />
                               </ScalarOperator>
                              </Intrinsic>
                              </ScalarOperator>
                             </Predicate>
                            </IndexScan>
                            </RelOp>
                           </NestedLoops>
                          </RelOp>
                          </Sort>
                         </RelOp>
                        </ComputeScalar>
                        </RelOp>
                        <RelOp NodeId="108" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="40" EstimatedTotalSubtreeCost="14.1533" TableCardinality="321194" Parallel="0" EstimateRebinds="16414.9" EstimateRewinds="36159.6">
                        <OutputList>
                         <ColumnReference Column="Column87" />
                         <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                        </OutputList>
                        <RunTimeInformation>
                         <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="0" ActualExecutions="61200" />
                        </RunTimeInformation>
                        <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                         <DefinedValues>
                          <DefinedValue>
                          <ColumnReference Column="Column87" />
                          </DefinedValue>
                          <DefinedValue>
                          <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                          </DefinedValue>
                         </DefinedValues>
                         <Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index8" IndexKind="NonClustered" />
                         <SeekPredicates>
                          <SeekPredicateNew>
                          <SeekKeys>
                           <Prefix ScanType="EQ">
                            <RangeColumns>
                            <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column56" />
                            </RangeColumns>
                            <RangeExpressions>
                            <ScalarOperator ScalarString="ScalarString26">
                             <Identifier>
                              <ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Column="Column78" />
                             </Identifier>
                            </ScalarOperator>
                            </RangeExpressions>
                           </Prefix>
                          </SeekKeys>
                          </SeekPredicateNew>
                         </SeekPredicates>
                        </IndexScan>
                        </RelOp>
                       </NestedLoops>
                      </RelOp>
                      </ComputeScalar>
                     </RelOp>
                     <RelOp NodeId="113" PhysicalOp="RID Lookup" LogicalOp="RID Lookup" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="321" EstimatedTotalSubtreeCost="8.60638" TableCardinality="321194" Parallel="0" EstimateRebinds="40150.9" EstimateRewinds="46.8646">
                      <OutputList>
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column27" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column28" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column29" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column30" />
                      <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                      </OutputList>
                      <RunTimeInformation>
                      <RunTimeCountersPerThread Thread="0" ActualRows="61200" ActualEndOfScans="0" ActualExecutions="61200" />
                      </RunTimeInformation>
                      <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                      <DefinedValues>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column26" />
                       </DefinedValue>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column27" />
                       </DefinedValue>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column28" />
                       </DefinedValue>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column29" />
                       </DefinedValue>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column30" />
                       </DefinedValue>
                       <DefinedValue>
                        <ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Column="Column31" />
                       </DefinedValue>
                      </DefinedValues>
                      <Object Database="Database1" Schema="Schema1" Table="Object5" TableReferenceId="-1" IndexKind="Heap" />
                      <SeekPredicates>
                       <SeekPredicateNew>
                        <SeekKeys>
                        <Prefix ScanType="EQ">
                         <RangeColumns>
                          <ColumnReference Column="Column87" />
                         </RangeColumns>
                         <RangeExpressions>
                          <ScalarOperator ScalarString="ScalarString27">
                          <Identifier>
                           <ColumnReference Column="Column87" />
                          </Identifier>
                          </ScalarOperator>
                         </RangeExpressions>
                        </Prefix>
                        </SeekKeys>
                       </SeekPredicateNew>
                      </SeekPredicates>
                      </IndexScan>
                     </RelOp>
                    </NestedLoops>
                    </RelOp>
                   </ComputeScalar>
                  </RelOp>
                  </Hash>
                 </RelOp>
                </Hash>
                </RelOp>
               </Hash>
              </RelOp>
              </Hash>
             </RelOp>
            </Hash>
            </RelOp>
           </Hash>
          </RelOp>
          </Hash>
         </RelOp>
        </Sort>
        </RelOp>
        <RelOp NodeId="137" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="46.4926" TableCardinality="1.25948e+006" Parallel="0" EstimateRebinds="43884.6" EstimateRewinds="0">
        <OutputList>
         <ColumnReference Database="Database1" Schema="Schema1" Table="Object9" Column="Column66" />
        </OutputList>
        <RunTimeInformation>
         <RunTimeCountersPerThread Thread="0" ActualRows="66997" ActualEndOfScans="67020" ActualExecutions="67020" />
        </RunTimeInformation>
        <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
         <DefinedValues>
          <DefinedValue>
          <ColumnReference Database="Database1" Schema="Schema1" Table="Object9" Column="Column66" />
          </DefinedValue>
         </DefinedValues>
         <Object Database="Database1" Schema="Schema1" Table="Object9" Index="Index9" IndexKind="Clustered" />
         <SeekPredicates>
          <SeekPredicateNew>
          <SeekKeys>
           <Prefix ScanType="EQ">
            <RangeColumns>
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object9" Column="Column85" />
            <ColumnReference Database="Database1" Schema="Schema1" Table="Object9" Column="Column78" />
            </RangeColumns>
            <RangeExpressions>
            <ScalarOperator ScalarString="ScalarString28">
             <Identifier>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object6" Column="Column46" />
             </Identifier>
            </ScalarOperator>
            <ScalarOperator ScalarString="ScalarString29">
             <Identifier>
              <ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Column="Column5" />
             </Identifier>
            </ScalarOperator>
            </RangeExpressions>
           </Prefix>
          </SeekKeys>
          </SeekPredicateNew>
         </SeekPredicates>
        </IndexScan>
        </RelOp>
       </NestedLoops>
      </RelOp>
      </QueryPlan>
     </StmtSimple>
    </Statements>
    </Batch>
  </BatchSequence>
  </ShowPlanXML>

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  February 12, 2018 at 10:52 pm

  #1979556

  Did you try the query with OPTION (RECOMPILE) at the end of it?

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• Sergiy

  SSC Guru

  Points: 110206

  More actions

  February 13, 2018 at 12:40 am

  #1979558

  Listen to what Scott said - the column which is used for range selection (e.g. BETWEEN ) must be the 1st column in the clustered index.

  Everything else would be a pity resemblance.

  Whatever method people will suggest to make the engine to use a non clustered index on the date field there would be "bookmark lookup" involved anyway, which is horribly slow.

  Some may suggest a covering index having the date as the first column,but that would create a copy of the data in the table, which would badly affect a INSERT and Update Statements.

  _____________
  Code for TallyGenerator

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  February 13, 2018 at 6:07 am

  #1979580

  The majority of your tables don't have a clustered index. It's highly unlikely that this omission is deliberate. Addressing the issue will change the execution plan of almost every query referencing this database. There is little point in optimising this query until your database has been properly redesigned.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden