Optimize on every execution Best execution plan for every query You end up paying for the optimization cost ALTER PROCEDURE test (@pid int) AS SELECT * FROM Sales.SalesOrderDetail WHERE ProductID = @pid OPTION (RECOMPILE) 15
{}