API tools faq
paste
Advertisement
Guest User

Fast

a guest
Sep 12th, 2011
235
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 29.06 KB | None | 0 0
raw download clone embed print report
  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]))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!