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 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 ...