AnsweredAssumed Answered

OLEDB Enterprise bug on detection of expensive queries?

Question asked by Roger Palmen on May 5, 2015
Latest reply on May 6, 2015 by Roger Palmen

Hi All,

 

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:

Capture.PNG

 

Page 50:

Typical queries are as follows:

 Event Frame attribute query = inner join of EventFrame.EventFrame and EventFrame. EventFrameAttribute.

Outcomes