Knowledge Base
Search Results ...
Avoiding Parameter Sniffing with Optimize For Unknown
Parameter sniffing is a common behavior in SQL Server 2012 and 2014, MySQL 5.6, DB2 10.5, and Azure SQL, where the SQL Server query optimizer uses the first-executed parameter value to estimate the cost and generate an execution plan. This is usually benef[.....]