Daytr8dr
Reputation: 1
Query Plan for Excel SQL Query
Does Excel (2016) create a SQL Query plan when connecting to an existing (SQL) connection from within Excel? Are there any disadvantages of using Excel to access database versus using a stored procedure in SQL Server?
Upvotes: 0
Views: 125
Answers (1)
Tab Alleman
Reputation: 31785
No, Excel does not create query plans. It simply sends a query to SQL Server, and the database engine creates the execution plan.
Upvotes: 2
Related Questions
- Parametizing query for Excel
- How to apply Excel operation into SQL server Query?
- Query data in Excel file with SQL Server table
- Excel Sheet SQL Table
- query excel with sql
- Write SQL query on excel tables
- VBA with sql query - optimization
- Fastest way to query a SQL Database from Excel?
- excel to sql help
- Using Microsoft Query and ODBC to SQL Server, complicated query