sorry for the lengthy post, kind of hard to describe the issue without pictures. Plainly put, SQL is using different query plans for the same query (depending on whether I use parameters or not). I understand this is an issue with parameter sniffing, but as I'm using Entity Framework, I don't have a way to use hints for my queries.sorry for the lengthy post, kind of hard to des
阅读背景：
SQL Server选择低效的计划（通过EntityFramework）
来源：互联网
分享到：
