Hi Dave,

The OPENQUERY sends query directly to the linked server for execution. Otherwise SQL Server query optimizer desides how to execute the query based on the statistic provided by OLE DB provider. It's documented quite well in the BOL.


>HI,
>
>I create a linked server between SQL et Oracle.
>
>Does exist a difference and what is the best to use between those syntax:
>
>select * from XYZ..SQL.EMPLOYEE
>
>OR
>
>select * from OPENQUERY(XYZ, 'Select * from EMPLOYEE')
>
>It weird because when I add a criteria greater than 34xxx, my performance is least faster...For Sample, select * from XYZ..SQL.EMPLOYEE where NoEmp = 40000
>
>Thank in advance,
>
>Dave
>Technologies Nter