Microsoft SQL Server 2005 Hints

In addition to the hints available in earlier SQL Server versions, SQL Server 2005 introduces many new hints, such as USE PLAN, FORCED PARAMETERIZATION, and so on. These hints can be used in all editions of SQL Server 2005.

SQL Server 2005 classifies hints broadly into three categories: join hints, query hints, and table hints. The entire list of hints included in these categories is explained in the sections below.

Join Hints

Join hints are used to enforce a join strategy between the joined tables. When no join hint is specified (the default case for a majority of the queries), the optimizer automatically selects the join type that is best suited for the query. With SQL Server 2005, you can use join hints to force ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.