1.3 The Drawbacks of Using Recompile Hints

So far, we’ve added indexes, broken up queries into sections to encourage SQL Server to use those indexes, and even added query-level hints, all in an effort to get one execution plan that works well enough for most scenarios. But what if you can’t? Recompile hints are so compelling because they get a brand new…

So far, we’ve added indexes, broken up queries into sections to encourage SQL Server to use those indexes, and even added query-level hints, all in an effort to get one execution plan that works well enough for most scenarios. But what if you can’t? Recompile hints are so compelling because they get a brand new...