O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

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

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