Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Fast

By: a guest on Sep 12th, 2011  |  syntax: SQL  |  size: 29.06 KB  |  views: 82  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.   |--Sort(ORDER BY:([Extent1].[ART_Asset_ID] ASC, [Extent2].[IDB_Ports_ID] ASC, [Expr1189] ASC, [Union1133] ASC, [Union1134] ASC, [Union1135] ASC, [Union1136] ASC, [Union1137] ASC, [Union1138] ASC, [Union1139] ASC, [Union1140] ASC, [Union1141] ASC, [Union1132] ASC))
  2.        |--Compute Scalar(DEFINE:([Expr1189]=CASE WHEN [Union1133] IS NULL THEN NULL ELSE (1) END))
  3.             |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
  4.                  |--Top(TOP EXPRESSION:((2)))
  5.                  |    |--Compute Scalar(DEFINE:([Expr1004]=CASE WHEN [HarNet].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID],0) END))
  6.                  |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
  7.                  |              |--Compute Scalar(DEFINE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID],0)))
  8.                  |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent1].[ART_Asset_ID]))
  9.                  |              |         |--Index Seek(OBJECT:([HarNet].[dbo].[ART_Asset].[IDX_ART_Asset_Host] AS [Extent1]), SEEK:([Extent1].[Host]='SDNI-U00-IR-01') ORDERED FORWARD)
  10.                  |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[ART_Asset].[PK_ART_Assets] AS [Extent1]), SEEK:([Extent1].[ART_Asset_ID]=[HarNet].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID]) LOOKUP ORDERED FORWARD)
  11.                  |              |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_Ports].[PK_IDB_Ports] AS [Extent2]), WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Ports].[ART_Asset_ID] as [Extent2].[ART_Asset_ID],0)))
  12.                  |--Concatenation
  13.                       |--Compute Scalar(DEFINE:([Expr1038]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE (1) END, [Expr1039]=(1), [Expr1045]=(1), [Expr1048]=(1), [Expr1053]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE (1) END, [Expr1054]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE CONVERT(int,[Expr1028],0) END, [Expr1055]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE CONVERT(int,[Expr1036],0) END, [Expr1056]=NULL, [Expr1057]=NULL, [Expr1058]=NULL, [Expr1059]=NULL, [Expr1060]=NULL, [Expr1061]=NULL, [Expr1062]=NULL))
  14.                       |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250]))
  15.                       |         |--Compute Scalar(DEFINE:([Expr1052]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0) END))
  16.                       |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1044]))
  17.                       |         |         |--Compute Scalar(DEFINE:([Expr1051]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0) END))
  18.                       |         |         |    |--Compute Scalar(DEFINE:([Expr1046]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0) END))
  19.                       |         |         |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250], [Expr1555]) OPTIMIZED WITH UNORDERED PREFETCH)
  20.                       |         |         |              |--Hash Match(Right Outer Join, HASH:([Expr1253])=([Expr1042]), RESIDUAL:([Expr1042]=[Expr1253]))
  21.                       |         |         |              |    |--Compute Scalar(DEFINE:([Expr1253]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0)))
  22.                       |         |         |              |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent10]))
  23.                       |         |         |              |    |--Compute Scalar(DEFINE:([Expr1050]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent9].[IDB_Interface_ID],0) END))
  24.                       |         |         |              |         |--Hash Match(Right Outer Join, HASH:([Expr1255])=([Expr1254]), RESIDUAL:([Expr1254]=[Expr1255]))
  25.                       |         |         |              |              |--Compute Scalar(DEFINE:([Expr1255]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID],0)))
  26.                       |         |         |              |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent9]))
  27.                       |         |         |              |              |--Compute Scalar(DEFINE:([Expr1049]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0) END))
  28.                       |         |         |              |                   |--Merge Join(Left Outer Join, MANY-TO-MANY MERGE:([Expr1254])=([Expr1256]), RESIDUAL:([Expr1254]=[Expr1256]))
  29.                       |         |         |              |                        |--Compute Scalar(DEFINE:([Expr1047]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent7].[IDB_Interface_ID],0) END))
  30.                       |         |         |              |                        |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250], [Expr1554]) WITH ORDERED PREFETCH)
  31.                       |         |         |              |                        |         |--Sort(ORDER BY:([Expr1254] ASC))
  32.                       |         |         |              |                        |         |    |--Compute Scalar(DEFINE:([Expr1254]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID],0) END))
  33.                       |         |         |              |                        |         |         |--Hash Match(Right Outer Join, HASH:([Expr1259])=([Expr1040]), RESIDUAL:([Expr1040]=[Expr1259]))
  34.                       |         |         |              |                        |         |              |--Compute Scalar(DEFINE:([Expr1259]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent5].[IDB_Interface_ID],0)))
  35.                       |         |         |              |                        |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent5]))
  36.                       |         |         |              |                        |         |              |--Compute Scalar(DEFINE:([Expr1250]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID],0) END))
  37.                       |         |         |              |                        |         |                   |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1040], [Expr1553]) OPTIMIZED WITH UNORDERED PREFETCH)
  38.                       |         |         |              |                        |         |                        |--Compute Scalar(DEFINE:([Expr1040]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID],0), [Expr1041]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0), [Expr1042]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent3].[NSD_InterfaceCodeID],0), [Expr1043]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent3].[ART_Component_ID],0), [Expr1044]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent3].[NSD_InterfaceTypeID],0)))
  39.                       |         |         |              |                        |         |                        |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent3].[IDB_Interface_ID], [Expr1552]) OPTIMIZED WITH UNORDERED PREFETCH)
  40.                       |         |         |              |                        |         |                        |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent3]), SEEK:([Extent3].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0)) ORDERED FORWARD)
  41.                       |         |         |              |                        |         |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent3]), SEEK:([Extent3].[IDB_Interface_ID]=[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
  42.                       |         |         |              |                        |         |                        |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent4]), SEEK:([Extent4].[IDB_Interface_ID]=[Expr1040]),  WHERE:([Expr1040]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent4].[IDB_Interface_ID],0)) ORDERED FORWARD)
  43.                       |         |         |              |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent7]), SEEK:([Extent7].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
  44.                       |         |         |              |                        |--Sort(ORDER BY:([Expr1256] ASC))
  45.                       |         |         |              |                             |--Compute Scalar(DEFINE:([Expr1256]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0)))
  46.                       |         |         |              |                                  |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent8]))
  47.                       |         |         |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent6]), SEEK:([Extent6].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
  48.                       |         |         |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent11]), WHERE:([Expr1044]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0)))
  49.                       |         |--Nested Loops(Inner Join)
  50.                       |              |--Compute Scalar(DEFINE:([Expr1028]=[HarNet].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID], [Expr1029]=[HarNet].[dbo].[IDB_LANinterface].[Speed] as [Extent12].[Speed], [Expr1030]=[HarNet].[dbo].[IDB_LANinterface].[Duplex] as [Extent12].[Duplex], [Expr1031]=[HarNet].[dbo].[IDB_LANinterface].[VLAN] as [Extent12].[VLAN], [Expr1032]=[HarNet].[dbo].[IDB_LANinterface].[ConnectorType] as [Extent12].[ConnectorType], [Expr1033]=[HarNet].[dbo].[IDB_LANinterface].[PortFast] as [Extent12].[PortFast], [Expr1034]=[HarNet].[dbo].[IDB_LANinterface].[PortSecurity] as [Extent12].[PortSecurity], [Expr1035]=[HarNet].[dbo].[IDB_LANinterface].[InterfaceStatus] as [Extent12].[InterfaceStatus], [Expr1036]=[HarNet].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID]))
  51.                       |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent12].[IDB_LANinterface_ID]) OPTIMIZED)
  52.                       |              |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_LANinterface].[IX_idb_laninterface_idb_laninterfacelayer2] AS [Extent12]), SEEK:([Extent12].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID],0)=[Expr1250]) ORDERED FORWARD)
  53.                       |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_LANinterface].[PK_IDB_LANinterface] AS [Extent12]), SEEK:([Extent12].[IDB_LANinterface_ID]=[HarNet].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID]) LOOKUP ORDERED FORWARD)
  54.                       |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent13]), SEEK:([Extent13].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent13].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
  55.                       |--Compute Scalar(DEFINE:([Expr1101]=(2), [Expr1102]=(2), [Expr1108]=(2), [Expr1111]=(2), [Expr1115]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0) END, [Expr1116]=NULL, [Expr1117]=NULL, [Expr1118]=NULL, [Expr1119]=NULL, [Expr1120]=NULL, [Expr1121]=NULL, [Expr1122]=NULL, [Expr1123]=NULL, [Expr1124]=NULL, [Expr1125]=NULL, [Expr1126]=(2), [Expr1128]=(2), [Expr1129]=CASE WHEN [Expr1093] IS NULL THEN NULL ELSE CONVERT(int,[Expr1093],0) END, [Expr1130]=CASE WHEN [Expr1099] IS NULL THEN NULL ELSE CASE WHEN [Expr1100] IS NULL THEN NULL ELSE CONVERT(int,[Expr1100],0) END END))
  56.                            |--Hash Match(Right Outer Join, HASH:([Expr1271])=([Expr1270]), RESIDUAL:([Expr1270]=[Expr1271]))
  57.                                 |--Compute Scalar(DEFINE:([Expr1100]=[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent30].[IDB_AddressMapIPv4_ID]))
  58.                                 |    |--Hash Match(Left Outer Join, HASH:([Expr1271])=([Expr1282]), RESIDUAL:([Expr1271]=[Expr1282]))
  59.                                 |         |--Compute Scalar(DEFINE:([Expr1099]=[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID], [Expr1271]=CONVERT(int,[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID],0)))
  60.                                 |         |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent29]))
  61.                                 |         |--Compute Scalar(DEFINE:([Expr1282]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent30].[IDB_AddressIPv4_ID],0)))
  62.                                 |              |--Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent30]))
  63.                                 |--Hash Match(Left Outer Join, HASH:([Expr1270])=([Expr1272]), RESIDUAL:([Expr1270]=[Expr1272]))
  64.                                      |--Compute Scalar(DEFINE:([Expr1109]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0) END))
  65.                                      |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1267], [Expr1561]) OPTIMIZED WITH UNORDERED PREFETCH)
  66.                                      |         |--Compute Scalar(DEFINE:([Expr1110]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent18].[IDB_Interface_ID],0) END))
  67.                                      |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1267], [Expr1560]) OPTIMIZED WITH UNORDERED PREFETCH)
  68.                                      |         |         |--Hash Match(Right Outer Join, HASH:([Expr1262])=([Expr1107]), RESIDUAL:([Expr1107]=[Expr1262]))
  69.                                      |         |         |    |--Compute Scalar(DEFINE:([Expr1262]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0)))
  70.                                      |         |         |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent22]))
  71.                                      |         |         |    |--Compute Scalar(DEFINE:([Expr1114]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0) END))
  72.                                      |         |         |         |--Hash Match(Right Outer Join, HASH:([Expr1263])=([Expr1105]), RESIDUAL:([Expr1105]=[Expr1263]))
  73.                                      |         |         |              |--Compute Scalar(DEFINE:([Expr1263]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0)))
  74.                                      |         |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent21]))
  75.                                      |         |         |              |--Compute Scalar(DEFINE:([Expr1113]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent20].[IDB_Interface_ID],0) END))
  76.                                      |         |         |                   |--Hash Match(Left Outer Join, HASH:([Expr1264])=([Expr1265]), RESIDUAL:([Expr1264]=[Expr1265]))
  77.                                      |         |         |                        |--Compute Scalar(DEFINE:([Expr1112]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0) END))
  78.                                      |         |         |                        |    |--Hash Match(Left Outer Join, HASH:([Expr1264])=([Expr1266]), RESIDUAL:([Expr1264]=[Expr1266]))
  79.                                      |         |         |                        |         |--Compute Scalar(DEFINE:([Expr1131]=CASE WHEN [HarNet].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID],0) END))
  80.                                      |         |         |                        |         |    |--Hash Match(Right Outer Join, HASH:([Expr1273])=([Expr1127]), RESIDUAL:([Expr1127]=[Expr1273]))
  81.                                      |         |         |                        |         |         |--Compute Scalar(DEFINE:([Expr1273]=CONVERT(int,[HarNet].[dbo].[IDB_StandbyIPv4].[IDB_AddressMapIPv4_ID] as [Extent25].[IDB_AddressMapIPv4_ID],0)))
  82.                                      |         |         |                        |         |         |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_StandbyIPv4].[PK_IDB_StandbyIPv4] AS [Extent25]))
  83.                                      |         |         |                        |         |         |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1275], [Expr1559]) WITH UNORDERED PREFETCH)
  84.                                      |         |         |                        |         |              |--Compute Scalar(DEFINE:([Expr1127]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0), [Expr1270]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent24].[IDB_AddressIPv4_ID],0)))
  85.                                      |         |         |                        |         |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1276], [Expr1558]) WITH UNORDERED PREFETCH)
  86.                                      |         |         |                        |         |              |         |--Hash Match(Inner Join, HASH:([Expr1275])=([Expr1264]), RESIDUAL:([Expr1264]=[Expr1275]))
  87.                                      |         |         |                        |         |              |         |    |--Compute Scalar(DEFINE:([Expr1275]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceIPv4].[IDB_InterfaceLayer3_ID] as [Extent23].[IDB_InterfaceLayer3_ID],0), [Expr1276]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceIPv4].[IDB_AddressMapIPv4_ID] as [Extent23].[IDB_AddressMapIPv4_ID],0)))
  88.                                      |         |         |                        |         |              |         |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceIPv4].[PK_IDB_InterfaceIPv4] AS [Extent23]))
  89.                                      |         |         |                        |         |              |         |    |--Compute Scalar(DEFINE:([Expr1264]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID],0) END))
  90.                                      |         |         |                        |         |              |         |         |--Hash Match(Right Outer Join, HASH:([Expr1277])=([Expr1103]), RESIDUAL:([Expr1103]=[Expr1277]))
  91.                                      |         |         |                        |         |              |         |              |--Compute Scalar(DEFINE:([Expr1277]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent16].[IDB_Interface_ID],0)))
  92.                                      |         |         |                        |         |              |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent16]))
  93.                                      |         |         |                        |         |              |         |              |--Compute Scalar(DEFINE:([Expr1267]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID],0) END))
  94.                                      |         |         |                        |         |              |         |                   |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1103], [Expr1557]) OPTIMIZED WITH UNORDERED PREFETCH)
  95.                                      |         |         |                        |         |              |         |                        |--Compute Scalar(DEFINE:([Expr1103]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID],0), [Expr1104]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0), [Expr1105]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent14].[NSD_InterfaceCodeID],0), [Expr1106]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent14].[ART_Component_ID],0), [Expr1107]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent14].[NSD_InterfaceTypeID],0)))
  96.                                      |         |         |                        |         |              |         |                        |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent14].[IDB_Interface_ID], [Expr1556]) OPTIMIZED WITH UNORDERED PREFETCH)
  97.                                      |         |         |                        |         |              |         |                        |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent14]), SEEK:([Extent14].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0)) ORDERED FORWARD)
  98.                                      |         |         |                        |         |              |         |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent14]), SEEK:([Extent14].[IDB_Interface_ID]=[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
  99.                                      |         |         |                        |         |              |         |                        |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent15]), SEEK:([Extent15].[IDB_Interface_ID]=[Expr1103]),  WHERE:([Expr1103]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent15].[IDB_Interface_ID],0)) ORDERED FORWARD)
  100.                                      |         |         |                        |         |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[PK_IDB_AddressMapIPv4] AS [Extent24]), SEEK:([Extent24].[IDB_AddressMapIPv4_ID]=[Expr1276]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0)=[Expr1276]) ORDERED FORWARD)
  101.                                      |         |         |                        |         |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent26]), SEEK:([Extent26].[IDB_InterfaceLayer3_ID]=[Expr1275]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent26].[IDB_InterfaceLayer3_ID],0)=[Expr1275]) ORDERED FORWARD)
  102.                                      |         |         |                        |         |--Compute Scalar(DEFINE:([Expr1266]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0)))
  103.                                      |         |         |                        |              |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent19]))
  104.                                      |         |         |                        |--Compute Scalar(DEFINE:([Expr1265]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID],0)))
  105.                                      |         |         |                             |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent20]))
  106.                                      |         |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent18]), SEEK:([Extent18].[IDB_InterfaceLayer2_ID]=[Expr1267]),  WHERE:([Expr1267]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
  107.                                      |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent17]), SEEK:([Extent17].[IDB_InterfaceLayer2_ID]=[Expr1267]),  WHERE:([Expr1267]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
  108.                                      |--Hash Match(Right Outer Join, HASH:([Expr1281])=([Expr1272]), RESIDUAL:([Expr1272]=[Expr1281]))
  109.                                           |--Compute Scalar(DEFINE:([Expr1281]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent28].[IDB_AddressIPv4_ID],0)))
  110.                                           |    |--Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent28]))
  111.                                           |--Compute Scalar(DEFINE:([Expr1093]=[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID], [Expr1094]=[HarNet].[dbo].[IDB_AddressIPv4].[Address] as [Extent27].[Address], [Expr1272]=CONVERT(int,[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID],0)))
  112.                                                |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent27]))