Hints are a powerful mechanism to force SQL Server to use alternate query plans. More often than not, the query optimizer does a fantastic job in creating the most optimized query plan for data access, but there may be numerous occasions when you would like to use alternate query plans to boost performance. Hints may adversely affect performance so should be used with care. In this breakout session, we first alert the DBAs on using Hints as they need to be sure that there is indeed a problem with the query plan. Let us have a look at different types of Hints including Query & Table Hints with various concepts on SQL Server query processing architecture are also explained wherever relevant, to ensure that the audience gets the most out of the session.

(no tags)