Want more features on Pastebin? Sign Up, it's FREE!
Guest

SLOW

By: a guest on Sep 12th, 2011  |  syntax: SQL  |  size: 27.36 KB  |  views: 108  |  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, [Expr1175] ASC, [Union1119] ASC, [Union1120] ASC, [Union1121] ASC, [Union1122] ASC, [Union1123] ASC, [Union1124] ASC, [Union1125] ASC, [Union1126] ASC, [Union1127] ASC, [Union1118] ASC))
  2.        |--Compute Scalar(DEFINE:([Expr1175]=CASE WHEN [Union1119] 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 [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))
  6.                  |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
  7.                  |              |--Compute Scalar(DEFINE:([Expr1005]=CONVERT(int,[NetINFO].[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:([NetINFO].[dbo].[ART_Asset].[IDX_ART_Asset_Host] AS [Extent1]), SEEK:([Extent1].[Host]='SDNI-U00-IR-01') ORDERED FORWARD)
  10.                  |              |         |--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)
  11.                  |              |--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)))
  12.                  |--Concatenation
  13.                       |--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))
  14.                       |    |--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))
  15.                       |         |--Hash Match(Left Outer Join, HASH:([Expr1237])=([Expr1238]), RESIDUAL:([Expr1237]=[Expr1238]))
  16.                       |              |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1237], [Expr1657]) OPTIMIZED WITH UNORDERED PREFETCH)
  17.                       |              |    |--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))
  18.                       |              |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1034]))
  19.                       |              |    |         |--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))
  20.                       |              |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1237], [Expr1656]) WITH ORDERED PREFETCH)
  21.                       |              |    |         |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1032]))
  22.                       |              |    |         |         |    |--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))
  23.                       |              |    |         |         |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1241], [Expr1655]) WITH ORDERED PREFETCH)
  24.                       |              |    |         |         |    |         |--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))
  25.                       |              |    |         |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1241], [Expr1654]) WITH ORDERED PREFETCH)
  26.                       |              |    |         |         |    |         |         |--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))
  27.                       |              |    |         |         |    |         |         |    |--Sort(ORDER BY:([Expr1237] ASC))
  28.                       |              |    |         |         |    |         |         |         |--Hash Match(Left Outer Join, HASH:([Expr1030])=([Expr1246]), RESIDUAL:([Expr1030]=[Expr1246]))
  29.                       |              |    |         |         |    |         |         |              |--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))
  30.                       |              |    |         |         |    |         |         |              |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1030], [Expr1653]) OPTIMIZED WITH UNORDERED PREFETCH)
  31.                       |              |    |         |         |    |         |         |              |         |--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)))
  32.                       |              |    |         |         |    |         |         |              |         |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent3].[IDB_Interface_ID], [Expr1652]) OPTIMIZED WITH UNORDERED PREFETCH)
  33.                       |              |    |         |         |    |         |         |              |         |         |--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)
  34.                       |              |    |         |         |    |         |         |              |         |         |--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)
  35.                       |              |    |         |         |    |         |         |              |         |--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)
  36.                       |              |    |         |         |    |         |         |              |--Compute Scalar(DEFINE:([Expr1246]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent5].[IDB_Interface_ID],0)))
  37.                       |              |    |         |         |    |         |         |                   |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent5]))
  38.                       |              |    |         |         |    |         |         |--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)
  39.                       |              |    |         |         |    |         |--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)
  40.                       |              |    |         |         |    |--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)))
  41.                       |              |    |         |         |--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)
  42.                       |              |    |         |--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)))
  43.                       |              |    |--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)
  44.                       |              |--Hash Match(Inner Join, HASH:([Expr1248])=([Expr1238]), RESIDUAL:([Expr1238]=[Expr1248]))
  45.                       |                   |--Compute Scalar(DEFINE:([Expr1248]=CONVERT(int,[NetINFO].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID],0)))
  46.                       |                   |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_LANinterface].[PK_IDB_LANinterface] AS [Extent12]))
  47.                       |                   |--Compute Scalar(DEFINE:([Expr1238]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent13].[IDB_InterfaceLayer2_ID],0)))
  48.                       |                        |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent13]))
  49.                       |--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))
  50.                            |--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))
  51.                                 |--Hash Match(Right Outer Join, HASH:([Expr1258])=([Expr1257]), RESIDUAL:([Expr1257]=[Expr1258]))
  52.                                      |--Hash Match(Left Outer Join, HASH:([Expr1258])=([Expr1269]), RESIDUAL:([Expr1258]=[Expr1269]))
  53.                                      |    |--Compute Scalar(DEFINE:([Expr1258]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID],0)))
  54.                                      |    |    |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent29]))
  55.                                      |    |--Compute Scalar(DEFINE:([Expr1269]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent30].[IDB_AddressIPv4_ID],0)))
  56.                                      |         |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent30]))
  57.                                      |--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))
  58.                                           |--Hash Match(Left Outer Join, HASH:([Expr1257])=([Expr1259]), RESIDUAL:([Expr1257]=[Expr1259]))
  59.                                                |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1254], [Expr1665]) OPTIMIZED WITH UNORDERED PREFETCH)
  60.                                                |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1093]))
  61.                                                |    |    |--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))
  62.                                                |    |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1254], [Expr1664]) OPTIMIZED WITH UNORDERED PREFETCH)
  63.                                                |    |    |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1091]))
  64.                                                |    |    |         |    |--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))
  65.                                                |    |    |         |    |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1251], [Expr1663]) WITH UNORDERED PREFETCH)
  66.                                                |    |    |         |    |         |--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))
  67.                                                |    |    |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1251], [Expr1662]) WITH UNORDERED PREFETCH)
  68.                                                |    |    |         |    |         |         |--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))
  69.                                                |    |    |         |    |         |         |    |--Hash Match(Left Outer Join, HASH:([Expr1113])=([Expr1260]), RESIDUAL:([Expr1113]=[Expr1260]))
  70.                                                |    |    |         |    |         |         |         |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1262], [Expr1661]) WITH UNORDERED PREFETCH)
  71.                                                |    |    |         |    |         |         |         |    |--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)))
  72.                                                |    |    |         |    |         |         |         |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1263], [Expr1660]) WITH UNORDERED PREFETCH)
  73.                                                |    |    |         |    |         |         |         |    |         |--Hash Match(Inner Join, HASH:([Expr1251])=([Expr1262]), RESIDUAL:([Expr1251]=[Expr1262]))
  74.                                                |    |    |         |    |         |         |         |    |         |    |--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))
  75.                                                |    |    |         |    |         |         |         |    |         |    |    |--Hash Match(Left Outer Join, HASH:([Expr1089])=([Expr1264]), RESIDUAL:([Expr1089]=[Expr1264]))
  76.                                                |    |    |         |    |         |         |         |    |         |    |         |--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))
  77.                                                |    |    |         |    |         |         |         |    |         |    |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1089], [Expr1659]) OPTIMIZED WITH UNORDERED PREFETCH)
  78.                                                |    |    |         |    |         |         |         |    |         |    |         |         |--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)))
  79.                                                |    |    |         |    |         |         |         |    |         |    |         |         |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent14].[IDB_Interface_ID], [Expr1658]) OPTIMIZED WITH UNORDERED PREFETCH)
  80. 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)
  81. 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)
  82.                                                |    |    |         |    |         |         |         |    |         |    |         |         |--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)
  83.                                                |    |    |         |    |         |         |         |    |         |    |         |--Compute Scalar(DEFINE:([Expr1264]=CONVERT(int,[NetINFO].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent16].[IDB_Interface_ID],0)))
  84.                                                |    |    |         |    |         |         |         |    |         |    |              |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent16]))
  85.                                                |    |    |         |    |         |         |         |    |         |    |--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)))
  86.                                                |    |    |         |    |         |         |         |    |         |         |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_InterfaceIPv4].[PK_IDB_InterfaceIPv4] AS [Extent23]))
  87.                                                |    |    |         |    |         |         |         |    |         |--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)
  88.                                                |    |    |         |    |         |         |         |    |--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)
  89.                                                |    |    |         |    |         |         |         |--Compute Scalar(DEFINE:([Expr1260]=CONVERT(int,[NetINFO].[dbo].[IDB_StandbyIPv4].[IDB_AddressMapIPv4_ID] as [Extent25].[IDB_AddressMapIPv4_ID],0)))
  90.                                                |    |    |         |    |         |         |              |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_StandbyIPv4].[PK_IDB_StandbyIPv4] AS [Extent25]))
  91.                                                |    |    |         |    |         |         |--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)
  92.                                                |    |    |         |    |         |--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)
  93.                                                |    |    |         |    |--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)))
  94.                                                |    |    |         |--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)
  95.                                                |    |    |--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)))
  96.                                                |    |--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)
  97.                                                |--Hash Match(Right Outer Join, HASH:([Expr1268])=([Expr1259]), RESIDUAL:([Expr1259]=[Expr1268]))
  98.                                                     |--Compute Scalar(DEFINE:([Expr1268]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent28].[IDB_AddressIPv4_ID],0)))
  99.                                                     |    |--Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent28]))
  100.                                                     |--Compute Scalar(DEFINE:([Expr1259]=CONVERT(int,[NetINFO].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID],0)))
  101.                                                          |--Clustered Index Scan(OBJECT:([NetINFO].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent27]))
clone this paste RAW Paste Data