优化未知的SQL Server 2005? [英] optimize for unknown for SQL Server 2005?

问题描述

我在听SO播客，他们提到SQL Server 2008的优化未知"，他们还提到SQL Server 2005也有类似的东西.有人知道这是什么吗?

I was listening to the SO podcast and they mentioned Optimize For Unknown for SQL server 2008, they also mentioned that there was something similar for SQL Server 2005. Anyone know what this is?

推荐答案

我遇到了这个问题...我知道它已经快一岁了.但是在存储过程中，您可以使用局部参数来模拟OPTIMIZE FOR UNKNOWN的行为. 请参阅与此相关的stackoverflow问题.

I came across this question... I know it's almost a year old. But Inside a stored procedure you can use a local parameter to mimic the behavior of OPTIMIZE FOR UNKNOWN. See this related stackoverflow question.

这篇关于优化未知的SQL Server 2005?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！