Forum Discussion
Excel & SQL Server Execution Plans and Perforamnce
Does Excel (2016) create or cause SQL Server to create an execution/query plan in SQL Server? Since Excel is creating the query that is hitting the DB, it should already be optimized, so does a quer...
Hi Aaron, was the query created with Power Query?
Your query will impact the server and amount if work the server will perform is dependent on how you've connected and, if using Power Query, how you've built your query
Your query will impact the server and amount if work the server will perform is dependent on how you've connected and, if using Power Query, how you've built your query