问题描述
正如标题所述，我不明白为什么sp_executeSQL会生成与从Sql Management Studio中运行查询相比完全不同的执行计划.
As the title states, I don't understand why the sp_executeSQL would generate a completely different execution plan than running the query from Sql Management Studio.
从SQL Management Studio运行时，我所查询的查询将花费3秒，而通过sp_executeSQL在Management Studio中运行的查询将花费5分钟.
My query in question will take 3 seconds when run from SQL management Studio, where as the query run in management studio via sp_executeSQL will take 5 minutes.
我已经更新了统计信息，并查看了索引，但事实仍然是，sp_executeSQL的执行计划远比直接从我的管理工作室运行sql更糟糕.
I've updated statistics, and reviewed indexes, but the fact remained in my head that the execution plan from sp_executeSQL was FAR worse than running the sql directly from my management studio.
这是我的问题:为什么执行计划在以两种不同方式运行查询之间会有如此大的差异?
So here is my question: Why would the execution plans differ SO much between running the query in these two different ways?
谢谢
推荐答案
请参见此
基本上，同一过程可以有多个[执行]计划
这篇关于通过sp_executeSQL过程执行时，为什么使用完全不同的执行计划会得到完全相同的SQL查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！