|--Sort(ORDER BY:([Extent1].[ART_Asset_ID] ASC, [Extent2].[IDB_Ports_ID] ASC, [Expr1175] ASC, [Union1119] ASC, [Union1120] ASC, [Union1121] ASC, [Union1122] ASC, [Union1123] ASC, [Union1124] ASC, [Union1125] ASC, [Union1126] ASC, [Union1127] ASC, [Union1118] ASC))
       |--Compute Scalar(DEFINE:([Expr1175]=CASE WHEN [Union1119] IS NULL THEN NULL ELSE (1) END))
            |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
                 |--Top(TOP EXPRESSION:((2)))
                 |    |--Compute Scalar(DEFINE:([Expr1004]=CASE WHEN [NetINFO].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID],0) END))
                 |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
                 |              |--Compute Scalar(DEFINE:([Expr1005]=CONVERT(int,[NetINFO].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID],0)))
                 |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent1].[ART_Asset_ID]))
                 |              |         |--Index Seek(OBJECT:([NetINFO].[dbo].[ART_Asset].[IDX_ART_Asset_Host] AS [Extent1]), SEEK:([Extent1].[Host]='SDNI-U00-IR-01') ORDERED FORWARD)
                 |              |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[ART_Asset].[PK_ART_Assets] AS [Extent1]), SEEK:([Extent1].[ART_Asset_ID]=[NetINFO].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID]) LOOKUP ORDERED FORWARD)
                 |              |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_Ports].[PK_IDB_Ports] AS [Extent2]), WHERE:([Expr1005]=CONVERT(int,[NetINFO].[dbo].[IDB_Ports].[ART_Asset_ID] as [Extent2].[ART_Asset_ID],0)))
                 |--Concatenation
                      |--Compute Scalar(DEFINE:([Expr1028]=CASE WHEN [NetINFO].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID] IS NULL THEN NULL ELSE (1) END, [Expr1029]=(1), [Expr1035]=(1), [Expr1038]=(1), [Expr1043]=CASE WHEN [NetINFO].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID] IS NULL THEN NULL ELSE (1) END, [Expr1044]=CASE WHEN [NetINFO].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID],0) END, [Expr1045]=CASE WHEN [NetINFO].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID],0) END, [Expr1046]=NULL, [Expr1047]=NULL, [Expr1048]=NULL, [Expr1049]=NULL, [Expr1050]=NULL, [Expr1051]=NULL, [Expr1052]=NULL))
                      |    |--Compute Scalar(DEFINE:([Expr1036]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0) END))
                      |         |--Hash Match(Left Outer Join, HASH:([Expr1237])=([Expr1238]), RESIDUAL:([Expr1237]=[Expr1238]))
                      |              |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1237], [Expr1657]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |              |    |--Compute Scalar(DEFINE:([Expr1042]=CASE WHEN [NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0) END))
                      |              |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1034]))
                      |              |    |         |--Compute Scalar(DEFINE:([Expr1037]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent7].[IDB_Interface_ID],0) END, [Expr1041]=CASE WHEN [NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0) END))
                      |              |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1237], [Expr1656]) WITH ORDERED PREFETCH)
                      |              |    |         |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1032]))
                      |              |    |         |         |    |--Compute Scalar(DEFINE:([Expr1040]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent9].[IDB_Interface_ID],0) END))
                      |              |    |         |         |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1241], [Expr1655]) WITH ORDERED PREFETCH)
                      |              |    |         |         |    |         |--Compute Scalar(DEFINE:([Expr1039]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0) END))
                      |              |    |         |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1241], [Expr1654]) WITH ORDERED PREFETCH)
                      |              |    |         |         |    |         |         |--Compute Scalar(DEFINE:([Expr1241]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID],0) END))
                      |              |    |         |         |    |         |         |    |--Sort(ORDER BY:([Expr1237] ASC))
                      |              |    |         |         |    |         |         |         |--Hash Match(Left Outer Join, HASH:([Expr1030])=([Expr1246]), RESIDUAL:([Expr1030]=[Expr1246]))
                      |              |    |         |         |    |         |         |              |--Compute Scalar(DEFINE:([Expr1237]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID],0) END))
                      |              |    |         |         |    |         |         |              |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1030], [Expr1653]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |              |    |         |         |    |         |         |              |         |--Compute Scalar(DEFINE:([Expr1030]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID],0), [Expr1031]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0), [Expr1032]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent3].[NSD_InterfaceCodeID],0), [Expr1033]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent3].[ART_Component_ID],0), [Expr1034]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent3].[NSD_InterfaceTypeID],0)))
                      |              |    |         |         |    |         |         |              |         |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent3].[IDB_Interface_ID], [Expr1652]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |              |    |         |         |    |         |         |              |         |         |--Index Seek(OBJECT:([NetINFO].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent3]), SEEK:([Extent3].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0)) ORDERED FORWARD)
                      |              |    |         |         |    |         |         |              |         |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent3]), SEEK:([Extent3].[IDB_Interface_ID]=[NetINFO].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
                      |              |    |         |         |    |         |         |              |         |--Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent4]), SEEK:([Extent4].[IDB_Interface_ID]=[Expr1030]),  WHERE:([Expr1030]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent4].[IDB_Interface_ID],0)) ORDERED FORWARD)
                      |              |    |         |         |    |         |         |              |--Compute Scalar(DEFINE:([Expr1246]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent5].[IDB_Interface_ID],0)))
                      |              |    |         |         |    |         |         |                   |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent5]))
                      |              |    |         |         |    |         |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent8]), SEEK:([Extent8].[IDB_InterfaceLayer3_ID]=[Expr1241]),  WHERE:([Expr1241]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0)) ORDERED FORWARD)
                      |              |    |         |         |    |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent9]), SEEK:([Extent9].[IDB_InterfaceLayer3_ID]=[Expr1241]),  WHERE:([Expr1241]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID],0)) ORDERED FORWARD)
                      |              |    |         |         |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent10]), WHERE:([Expr1032]=CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0)))
                      |              |    |         |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent7]), SEEK:([Extent7].[IDB_InterfaceLayer2_ID]=[Expr1237]),  WHERE:([Expr1237]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                      |              |    |         |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent11]), WHERE:([Expr1034]=CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0)))
                      |              |    |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent6]), SEEK:([Extent6].[IDB_InterfaceLayer2_ID]=[Expr1237]),  WHERE:([Expr1237]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                      |              |--Hash Match(Inner Join, HASH:([Expr1248])=([Expr1238]), RESIDUAL:([Expr1238]=[Expr1248]))
                      |                   |--Compute Scalar(DEFINE:([Expr1248]=CONVERT(int,[NetINFO].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID],0)))
                      |                   |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_LANinterface].[PK_IDB_LANinterface] AS [Extent12]))
                      |                   |--Compute Scalar(DEFINE:([Expr1238]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent13].[IDB_InterfaceLayer2_ID],0)))
                      |                        |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent13]))
                      |--Compute Scalar(DEFINE:([Expr1087]=(2), [Expr1088]=(2), [Expr1094]=(2), [Expr1097]=(2), [Expr1101]=CASE WHEN [NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0) END, [Expr1102]=NULL, [Expr1103]=NULL, [Expr1104]=NULL, [Expr1105]=NULL, [Expr1106]=NULL, [Expr1107]=NULL, [Expr1108]=NULL, [Expr1109]=NULL, [Expr1110]=NULL, [Expr1111]=NULL, [Expr1112]=(2), [Expr1114]=(2), [Expr1116]=CASE WHEN [NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID] IS NULL THEN NULL ELSE CASE WHEN [NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent30].[IDB_AddressMapIPv4_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent30].[IDB_AddressMapIPv4_ID],0) END END))
                           |--Compute Scalar(DEFINE:([Expr1095]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0) END))
                                |--Hash Match(Right Outer Join, HASH:([Expr1258])=([Expr1257]), RESIDUAL:([Expr1257]=[Expr1258]))
                                     |--Hash Match(Left Outer Join, HASH:([Expr1258])=([Expr1269]), RESIDUAL:([Expr1258]=[Expr1269]))
                                     |    |--Compute Scalar(DEFINE:([Expr1258]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID],0)))
                                     |    |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent29]))
                                     |    |--Compute Scalar(DEFINE:([Expr1269]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent30].[IDB_AddressIPv4_ID],0)))
                                     |         |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent30]))
                                     |--Compute Scalar(DEFINE:([Expr1115]=CASE WHEN [NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID],0) END))
                                          |--Hash Match(Left Outer Join, HASH:([Expr1257])=([Expr1259]), RESIDUAL:([Expr1257]=[Expr1259]))
                                               |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1254], [Expr1665]) OPTIMIZED WITH UNORDERED PREFETCH)
                                               |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1093]))
                                               |    |    |--Compute Scalar(DEFINE:([Expr1096]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent18].[IDB_Interface_ID],0) END, [Expr1100]=CASE WHEN [NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0) END))
                                               |    |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1254], [Expr1664]) OPTIMIZED WITH UNORDERED PREFETCH)
                                               |    |    |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1091]))
                                               |    |    |         |    |--Compute Scalar(DEFINE:([Expr1099]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent20].[IDB_Interface_ID],0) END))
                                               |    |    |         |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1251], [Expr1663]) WITH UNORDERED PREFETCH)
                                               |    |    |         |    |         |--Compute Scalar(DEFINE:([Expr1098]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0) END))
                                               |    |    |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1251], [Expr1662]) WITH UNORDERED PREFETCH)
                                               |    |    |         |    |         |         |--Compute Scalar(DEFINE:([Expr1117]=CASE WHEN [NetINFO].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID],0) END))
                                               |    |    |         |    |         |         |    |--Hash Match(Left Outer Join, HASH:([Expr1113])=([Expr1260]), RESIDUAL:([Expr1113]=[Expr1260]))
                                               |    |    |         |    |         |         |         |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1262], [Expr1661]) WITH UNORDERED PREFETCH)
                                               |    |    |         |    |         |         |         |    |--Compute Scalar(DEFINE:([Expr1113]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0), [Expr1257]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent24].[IDB_AddressIPv4_ID],0)))
                                               |    |    |         |    |         |         |         |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1263], [Expr1660]) WITH UNORDERED PREFETCH)
                                               |    |    |         |    |         |         |         |    |         |--Hash Match(Inner Join, HASH:([Expr1251])=([Expr1262]), RESIDUAL:([Expr1251]=[Expr1262]))
                                               |    |    |         |    |         |         |         |    |         |    |--Compute Scalar(DEFINE:([Expr1251]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID],0) END))
                                               |    |    |         |    |         |         |         |    |         |    |    |--Hash Match(Left Outer Join, HASH:([Expr1089])=([Expr1264]), RESIDUAL:([Expr1089]=[Expr1264]))
                                               |    |    |         |    |         |         |         |    |         |    |         |--Compute Scalar(DEFINE:([Expr1254]=CASE WHEN [NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID],0) END))
                                               |    |    |         |    |         |         |         |    |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1089], [Expr1659]) OPTIMIZED WITH UNORDERED PREFETCH)
                                               |    |    |         |    |         |         |         |    |         |    |         |         |--Compute Scalar(DEFINE:([Expr1089]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID],0), [Expr1090]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0), [Expr1091]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent14].[NSD_InterfaceCodeID],0), [Expr1092]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent14].[ART_Component_ID],0), [Expr1093]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent14].[NSD_InterfaceTypeID],0)))
                                               |    |    |         |    |         |         |         |    |         |    |         |         |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent14].[IDB_Interface_ID], [Expr1658]) OPTIMIZED WITH UNORDERED PREFETCH)
Index Seek(OBJECT:([NetINFO].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent14]), SEEK:([Extent14].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[NetINFO].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0)) ORDERED FORWARD)
Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent14]), SEEK:([Extent14].[IDB_Interface_ID]=[NetINFO].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
                                               |    |    |         |    |         |         |         |    |         |    |         |         |--Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent15]), SEEK:([Extent15].[IDB_Interface_ID]=[Expr1089]),  WHERE:([Expr1089]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent15].[IDB_Interface_ID],0)) ORDERED FORWARD)
                                               |    |    |         |    |         |         |         |    |         |    |         |--Compute Scalar(DEFINE:([Expr1264]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent16].[IDB_Interface_ID],0)))
                                               |    |    |         |    |         |         |         |    |         |    |              |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent16]))
                                               |    |    |         |    |         |         |         |    |         |    |--Compute Scalar(DEFINE:([Expr1262]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceIPv4].[IDB_InterfaceLayer3_ID] as [Extent23].[IDB_InterfaceLayer3_ID],0), [Expr1263]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceIPv4].[IDB_AddressMapIPv4_ID] as [Extent23].[IDB_AddressMapIPv4_ID],0)))
                                               |    |    |         |    |         |         |         |    |         |         |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceIPv4].[PK_IDB_InterfaceIPv4] AS [Extent23]))
                                               |    |    |         |    |         |         |         |    |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_AddressMapIPv4].[PK_IDB_AddressMapIPv4] AS [Extent24]), SEEK:([Extent24].[IDB_AddressMapIPv4_ID]=[Expr1263]),  WHERE:(CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0)=[Expr1263]) ORDERED FORWARD)
                                               |    |    |         |    |         |         |         |    |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent26]), SEEK:([Extent26].[IDB_InterfaceLayer3_ID]=[Expr1262]),  WHERE:(CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent26].[IDB_InterfaceLayer3_ID],0)=[Expr1262]) ORDERED FORWARD)
                                               |    |    |         |    |         |         |         |--Compute Scalar(DEFINE:([Expr1260]=CONVERT(int,[NetINFO].[dbo].[IDB_StandbyIPv4].[IDB_AddressMapIPv4_ID] as [Extent25].[IDB_AddressMapIPv4_ID],0)))
                                               |    |    |         |    |         |         |              |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_StandbyIPv4].[PK_IDB_StandbyIPv4] AS [Extent25]))
                                               |    |    |         |    |         |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent19]), SEEK:([Extent19].[IDB_InterfaceLayer3_ID]=[Expr1251]),  WHERE:([Expr1251]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0)) ORDERED FORWARD)
                                               |    |    |         |    |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent20]), SEEK:([Extent20].[IDB_InterfaceLayer3_ID]=[Expr1251]),  WHERE:([Expr1251]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID],0)) ORDERED FORWARD)
                                               |    |    |         |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent21]), WHERE:([Expr1091]=CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0)))
                                               |    |    |         |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent18]), SEEK:([Extent18].[IDB_InterfaceLayer2_ID]=[Expr1254]),  WHERE:([Expr1254]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                                               |    |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent22]), WHERE:([Expr1093]=CONVERT(int,[NetINFO].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0)))
                                               |    |--Clustered Index Seek(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent17]), SEEK:([Extent17].[IDB_InterfaceLayer2_ID]=[Expr1254]),  WHERE:([Expr1254]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                                               |--Hash Match(Right Outer Join, HASH:([Expr1268])=([Expr1259]), RESIDUAL:([Expr1259]=[Expr1268]))
                                                    |--Compute Scalar(DEFINE:([Expr1268]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent28].[IDB_AddressIPv4_ID],0)))
                                                    |    |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent28]))
                                                    |--Compute Scalar(DEFINE:([Expr1259]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID],0)))
                                                         |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent27]))