API tools faq
paste
Advertisement
Guest User

SLOW

a guest
Sep 12th, 2011
269
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 27.36 KB | None | 0 0
raw download clone embed print report
  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]))
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!