Query Execution Scenarios

When evaluating a distributed query, SQL Server interacts with the OLE DB provider in one or more of these scenarios:

• Remote query
• Indexed access
• Pure table scans
• UPDATE and DELETE statements
• INSERT statement
• Pass-through queries