BUG: Heterogeneous Query Showplan May Not Display Site Name (197562)

MORE INFORMATION

In the example below, the site ([server1]) shows where the clustered index seek is performed.

   Query:
   Select * from server2.pubs.dbo.authors A INNER REMOTE JOIN
   server1.pubs.dbo.authors B on A.au_id = B.au_id

      |--Nested Loops(Inner Join)
         |--Remote Query(SELECT A."au_id" Col1002,A."au_lname"
   Col1003,A."au_fname" Col1004,A."phone" Col1005,A."address"
   Col1006,A."city"
   Col1007,A."state" Col1008,A."zip" Col1009,A."contract" Col1010 FROM
   "pubs"."dbo"."authors" A)
         |--Clustered Index
   Seek(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [B]),
   SEEK:([B].[au_id]=[server1].[pubs].[dbo].[authors].[au_id]) ORDERED)
				

In the next example, the site where the clustered index scan is performed is not displayed.

  Query:
   Select * from server1.pubs.dbo.authors A INNER REMOTE JOIN
   server2.pubs.dbo.authors B on A.au_id = B.au_id
   
      |--Nested Loops(Inner Join)
         |--Clustered Index
   Scan(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [A]))
         |--Remote Query(SELECT B."au_id" Col1002,B."au_lname"
   Col1003,B."au_fname" Col1004,B."phone" Col1005,B."address"
   Col1006,B."city"
   Col1007,B."state" Col1008,B."zip" Col1009,B."contract" Col1010 FROM
   "pubs"."dbo"."authors" B WHERE ?=B."au_id")