"Parameter sniffing" refers to a process whereby SQL Server's execution environment "sniffs" the current parameter values during compilation or recompilation, and passes it along to the query optimizer so that they can be used to generate potentially faster query execution plans. The word "current" refers to the parameter values present in the statement call that caused a compilation or a recompilation.
Check out the complete article about Parameter sniffing
Tuesday, July 28, 2009
Parameter Sniffing & Stored Procedures Execution Plan
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment