Check out the Pastebin Gadgets Shop. We have thousands of fun, geeky & affordable gadgets on sale :-)Want more features on Pastebin? Sign Up, it's FREE!
tweet

# Fast

By: a guest on Sep 12th, 2011  |  syntax: SQL  |  size: 29.06 KB  |  views: 85  |  expires: Never
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]))
58.                                 |    |--Hash Match(Left Outer Join, HASH:([Expr1271])=([Expr1282]), RESIDUAL:([Expr1271]=[Expr1282]))
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]))
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)
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)
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]))