Using OLEDB Enterprise 2012, i get the following "expensive query" warning. I think this is not correct, as the ID is constrained:
OLE DB provider "PIOLEDBENT" for linked server "AFSERVER" returned message "[Sandbox.EventFrame.EventFrameAttribute Tbl1012] 'EventFrameID' column is not restricted. Such a query is considered expensive.
INNER JOIN AFSERVER.[Sandbox].EventFrame.EventFrameAttribute EFA ON (EF.ID = EFA.EventFrameID)
Even the manual states there is no direct relationship between EventFrameHierarchy and EventFrameAttribute:
Typical queries are as follows:
Event Frame attribute query = inner join of EventFrame.EventFrame and EventFrame. EventFrameAttribute.