Which Of The Following Function Will Be Preferred For Faster #428

Which of the following function will be preferred for faster execution in following code?</p> <pre><code class="language-sql">SELECT RemoteOrders.* FROM ________(Northwinds, "select * from orders") RemoteOrders left join MasterOrders on RemoteOrders.OrderId = MasterOrders.OrderId WHERE MasterOrders.OrderID = null </code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Data Connectivity - Distributed Queries - Quiz No.1.

SELECT RemoteOrders.* FROM ________(Northwinds, "select * from orders") RemoteOrders left join MasterOrders on RemoteOrders.OrderId = MasterOrders.OrderId WHERE MasterOrders.OrderID = null