Here's the sql plan.
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="11.0.5582.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementId="1" StatementText=" SET TRANSACTION ISOLATION LEVEL READ COMMITTED; " StatementType="SET TRANSACTION ISOLATION LEVEL" RetrievedFromCache="false" />
</Statements>
<Statements>
<StmtSimple StatementCompId="2" StatementId="2" StatementText=" SET NOCOUNT OFF ---ON; " StatementType="SET ON/OFF" RetrievedFromCache="false" />
</Statements>
<Statements>
<StmtSimple StatementCompId="3" StatementEstRows="20000" StatementId="3" StatementOptmLevel="FULL" StatementSubTreeCost="240.172" StatementText=" SELECT TOP ( 20000 ) ADDRESS_ID FROM DBO.ADDRESS WHERE ADDRESS.ADDRESS_ID IN ( SELECT ADDRESS.address_id FROM ADDRESS LEFT OUTER JOIN EARLY_PAYOFF_INFO EPI1 ON EPI1.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN EARLY_PAYOFF_INFO EPI2 ON EPI2.ADDRESS_ID1 = ADDRESS.ADDRESS_ID LEFT OUTER JOIN EARLY_PAYOFF_INFO EPI3 ON EPI3.ADDRESS_ID2 = ADDRESS.ADDRESS_ID LEFT OUTER JOIN CHECK_REQUEST_DEFAULT_ADDRESS ON CHECK_REQUEST_DEFAULT_ADDRESS.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN DIRECT_LENDING_SERVICE ON DIRECT_LENDING_SERVICE.PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN PACKET ON PACKET.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN WORK_QUEUE_ITEM ON WORK_QUEUE_ITEM.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN LEGAL_ENTITY ON LEGAL_ENTITY.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN SERVICE_REQUEST ON SERVICE_REQUEST.ADDRESS_ID = ADDRESS.ADDRESS_ID LEFT OUTER JOIN LIENHOLDER ON LIENHOLDER.ADDRESS_ID = ADDRESS.ADDRESS_ID WHERE EPI1.EARLY_PAYOFF_INFO_ID IS NULL AND EPI2.EARLY_PAYOFF_INFO_ID IS NULL AND EPI3.EARLY_PAYOFF_INFO_ID IS NULL AND CHECK_REQUEST_DEFAULT_ADDRESS.CHECK_REQUEST_DEFAULT_ADDRESS_ID IS NULL AND DIRECT_LENDING_SERVICE.DIRECT_LENDING_SERVICE_ID IS NULL AND WORK_QUEUE_ITEM.ADDRESS_ID IS NULL AND PACKET.PACKET_ID IS NULL AND LEGAL_ENTITY.LEGAL_ENTITY_ID IS NULL AND SERVICE_REQUEST.SERVICE_REQUEST_ID IS NULL AND LIENHOLDER.ADDRESS_ID IS NULL ) ORDER BY ADDRESS_ID OPTION ( MAXDOP 8 ); " StatementType="SELECT" QueryHash="0xB611CCC53C7FE1C4" QueryPlanHash="0xF1FE424191871166" RetrievedFromCache="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="144" CompileTime="646" CompileCPU="528" CompileMemory="3472">
<ThreadStat Branches="13" />
<MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="98960" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="262144" EstimatedPagesCached="524288" EstimatedAvailableDegreeOfParallelism="8" />
<RelOp AvgRowSize="11" EstimateCPU="0.002" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="240.172">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Top RowCount="false" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(20000)">
<Const ConstValue="(20000)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="11" EstimateCPU="0.108211" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20000" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="240.17">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="120.868" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20000" LogicalOp="Left Semi Join" NodeId="2" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="240.062">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="13.356" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="48.4867">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="62.9001" EstimateIO="4819.74" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="35.1307" TableCardinality="457455000">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Index="[ADDRESS_PK]" TableReferenceId="1" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.11181" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20565.7" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="190.67">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="0.357676" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20565.7" LogicalOp="Aggregate" NodeId="6" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="190.558">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<StreamAggregate>
<DefinedValues />
<GroupBy>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</GroupBy>
<RelOp AvgRowSize="11" EstimateCPU="3.17512" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20606.5" LogicalOp="Filter" NodeId="7" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="190.556">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="87.7147" EstimateIO="246.794" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="380717" LogicalOp="Right Outer Join" NodeId="8" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="190.533">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[LIENHOLDER].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="2.93025" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="716557" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="4.28974">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="13.695" EstimateIO="174.837" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="716557" LogicalOp="Index Scan" NodeId="10" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.35949" TableCardinality="99599500">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Index="[_dta_index_LIENHOLDER_5_1413580074__K5]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="7.31692" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="363316" LogicalOp="Filter" NodeId="11" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="183.179">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="112.059" EstimateIO="341.213" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="877346" LogicalOp="Right Outer Join" NodeId="12" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="183.126">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="SERVICE_REQUEST_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[SERVICE_REQUEST].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="15" EstimateCPU="2.50983" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="598711" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="4.33488">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="SERVICE_REQUEST_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="11.4427" EstimateIO="241.801" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="598711" LogicalOp="Index Scan" NodeId="14" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.82505" TableCardinality="83219200">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="SERVICE_REQUEST_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="SERVICE_REQUEST_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Index="[index_ServiceRequest_AddressId]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4643" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="876355" LogicalOp="Filter" NodeId="15" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="174.014">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="484.699" EstimateIO="1643.66" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3293150" LogicalOp="Right Outer Join" NodeId="16" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="173.817">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="LEGAL_ENTITY_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[LEGAL_ENTITY].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="15" EstimateCPU="13.7772" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3317410" LogicalOp="Repartition Streams" NodeId="17" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="21.2346">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="LEGAL_ENTITY_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="63.4028" EstimateIO="972.724" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3317410" LogicalOp="Index Scan" NodeId="18" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="7.45741" TableCardinality="461111000">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="LEGAL_ENTITY_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="LEGAL_ENTITY_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Index="[index_LegalEntity_AddressId]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="19" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="131.583">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="147.912" EstimateIO="1.19491" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Right Outer Join" NodeId="20" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="131.386">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[WORK_QUEUE_ITEM].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="2.42144" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="590911" LogicalOp="Repartition Streams" NodeId="21" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="3.64254">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="11.2936" EstimateIO="158.002" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="590911" LogicalOp="Index Scan" NodeId="22" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.2211" TableCardinality="82135100">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Index="[idx_address]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="23" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="120.987">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="126.569" EstimateIO="0.218633" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Right Outer Join" NodeId="24" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="120.789">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="PACKET_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[PACKET].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="15" EstimateCPU="0.0970953" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16544.4" LogicalOp="Repartition Streams" NodeId="25" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.140094">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="PACKET_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.316217" EstimateIO="5.22683" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16544.4" LogicalOp="Index Scan" NodeId="26" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0429986" TableCardinality="2299620">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="PACKET_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="PACKET_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Index="[idx_address]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="27" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="114.054">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="126.308" EstimateIO="1.38245" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Right Outer Join" NodeId="28" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="113.856">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="DIRECT_LENDING_SERVICE_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[DIRECT_LENDING_SERVICE].[PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="15" EstimateCPU="0.0490204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4944.41" LogicalOp="Repartition Streams" NodeId="29" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0624888">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="DIRECT_LENDING_SERVICE_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.0945177" EstimateIO="1.34387" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4944.41" LogicalOp="Index Scan" NodeId="30" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0134684" TableCardinality="687259">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="DIRECT_LENDING_SERVICE_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="DIRECT_LENDING_SERVICE_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="PREV_LIENHOLDER_MAIL_TO_ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Index="[idx_PREV_LIENHOLDER_MAIL_TO_ADDRESS]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="31" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="107.192">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="0.0285332" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Repartition Streams" NodeId="32" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="106.994">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="125.933" EstimateIO="0.0334788" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Right Outer Join" NodeId="33" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="106.966">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
</OutputList>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[CHECK_REQUEST_DEFAULT_ADDRESS].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="15" EstimateCPU="0.0287329" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="49.2528" LogicalOp="Repartition Streams" NodeId="34" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0320096">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.00096095" EstimateIO="0.0209028" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="49.2528" LogicalOp="Index Scan" NodeId="35" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.00327672" TableCardinality="6846">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Index="[idx_address]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="36" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="100.344">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="125.992" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Left Outer Join" NodeId="37" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="100.147">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="EARLY_PAYOFF_INFO_ID" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[ADDRESS_ID2] as [EPI3].[ADDRESS_ID2]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="38" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="93.5016">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="125.992" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Left Outer Join" NodeId="39" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="93.3041">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[ADDRESS_ID1] as [EPI2].[ADDRESS_ID1]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="27.4473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Filter" NodeId="40" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="70.9941">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="15" EstimateCPU="125.992" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Left Outer Join" NodeId="41" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="70.7967">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[ADDRESS_ID] as [EPI1].[ADDRESS_ID]=[cmsperformance].[dbo].[ADDRESS].[ADDRESS_ID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="11" EstimateCPU="13.356" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Repartition Streams" NodeId="42" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="48.4867">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="11" EstimateCPU="62.9001" EstimateIO="4819.74" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3291110" LogicalOp="Clustered Index Scan" NodeId="43" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="35.1307" TableCardinality="457455000">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[ADDRESS]" Index="[ADDRESS_PK]" TableReferenceId="2" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="8.12372" EstimateIO="0.00140766" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5231.39" LogicalOp="Sort" NodeId="44" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="15.7258">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</OutputList>
<MemoryFractions Input="0.5" Output="0.5" />
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.315292" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="727149" LogicalOp="Repartition Streams" NodeId="45" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="7.60064">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</PartitionColumns>
<RelOp AvgRowSize="15" EstimateCPU="0.100003" EstimateIO="7.18535" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="727149" LogicalOp="Clustered Index Scan" NodeId="46" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="7.28535" TableCardinality="727149">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="ADDRESS_ID" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Index="[EARLY_PAYOFF_INFO_PK]" Alias="[EPI1]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[EARLY_PAYOFF_INFO_ID] as [EPI1].[EARLY_PAYOFF_INFO_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI1]" Column="EARLY_PAYOFF_INFO_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="8.12372" EstimateIO="0.00140766" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5231.39" LogicalOp="Sort" NodeId="49" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="15.7258">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</OutputList>
<MemoryFractions Input="0.5" Output="0.5" />
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.315292" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="727149" LogicalOp="Repartition Streams" NodeId="50" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="7.60064">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</PartitionColumns>
<RelOp AvgRowSize="15" EstimateCPU="0.100003" EstimateIO="7.18535" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="727149" LogicalOp="Clustered Index Scan" NodeId="51" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="7.28535" TableCardinality="727149">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="ADDRESS_ID1" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Index="[EARLY_PAYOFF_INFO_PK]" Alias="[EPI2]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[EARLY_PAYOFF_INFO_ID] as [EPI2].[EARLY_PAYOFF_INFO_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI2]" Column="EARLY_PAYOFF_INFO_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.0502098" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5231.39" LogicalOp="Repartition Streams" NodeId="54" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0607766">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="0.100003" EstimateIO="0.934977" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5231.39" LogicalOp="Index Scan" NodeId="55" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0105668" TableCardinality="727149">
<OutputList>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="EARLY_PAYOFF_INFO_ID" />
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="EARLY_PAYOFF_INFO_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="ADDRESS_ID2" />
</DefinedValue>
</DefinedValues>
<Object Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Index="[index_Early_Payoff_Info_Address_Id2]" Alias="[EPI3]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[EARLY_PAYOFF_INFO].[EARLY_PAYOFF_INFO_ID] as [EPI3].[EARLY_PAYOFF_INFO_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[EARLY_PAYOFF_INFO]" Alias="[EPI3]" Column="EARLY_PAYOFF_INFO_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
</Parallelism>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[CHECK_REQUEST_DEFAULT_ADDRESS].[CHECK_REQUEST_DEFAULT_ADDRESS_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[CHECK_REQUEST_DEFAULT_ADDRESS]" Column="CHECK_REQUEST_DEFAULT_ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[DIRECT_LENDING_SERVICE].[DIRECT_LENDING_SERVICE_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[DIRECT_LENDING_SERVICE]" Column="DIRECT_LENDING_SERVICE_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[PACKET].[PACKET_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[PACKET]" Column="PACKET_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[WORK_QUEUE_ITEM].[ADDRESS_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[WORK_QUEUE_ITEM]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[LEGAL_ENTITY].[LEGAL_ENTITY_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LEGAL_ENTITY]" Column="LEGAL_ENTITY_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[SERVICE_REQUEST].[SERVICE_REQUEST_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[SERVICE_REQUEST]" Column="SERVICE_REQUEST_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Merge>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[cmsperformance].[dbo].[LIENHOLDER].[ADDRESS_ID] IS NULL">
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[cmsperformance]" Schema="[dbo]" Table="[LIENHOLDER]" Column="ADDRESS_ID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
</Merge>
</RelOp>
</Parallelism>
</RelOp>
</Top>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>