Que: Which of the following function will be preferred for faster execution in following code?

SELECT
RemoteOrders.*
FROM
________(Northwinds, "select * from orders")
RemoteOrders LEFT JOIN MasterOrders ON
RemoteOrders.OrderId = MasterOrders.OrderId
WHERE
MasterOrders.OrderID = NULL
a. OpenRow
b. OpenSQL
c. OpenQuery
d. All of the mentioned
Answer: OpenQuery

Leave a Comment