What’s New in Query Optimization
SQL Server 2008 introduces a few new features and capabilities related to query optimization and query performance in an attempt to deliver on the theme of “predictable performance.” The primary new features and enhancements are as follows:
• An enhancement has been added to the OPTIMIZE FOR query hint option to include a new UNKNOWN option, which specifies that the Database Engine use statistical data to determine the values for one or more local variables during query optimization, instead of the initial values.
• Table hints can now be specified as query hints in the context of plan guides to provide advanced query performance tuning options
• A new FORCESEEK table hint has been added. This hint specifies ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
