O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing query hints for optimized performance

In continuation of the previous recipe, the query hints are useful when you are in control on table design and data, and not to mention about data distribution, which is a critical aspect to obtain optimized performance. However, the query hints implementation is not a compulsion to use at all times. The hints will always provide a short-term result—that satisfies the existing result set—which may not be efficient over a period of time due to the data changes on the table. A new enhancement has been added to the OPTIMIZE FOR UNKNOWN query hint to include new statistical data to determine values for local variables during the query optimization instead of default values. Similarly, if the data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required