Rajesh S. Chandan

• Nov 6th, 2005

 

There are there types of hints : Query Hints, Index hints and lock hints and used for forcing the behavior of the statement as per our expectation.

Covering index will cover will have same columns in the select and where cause and index covers all the columns.

Bobby

• Oct 13th, 2007

 

Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query.

psingla

 Profile Answers by psingla Questions by psingla

• Mar 17th, 2010

 

Hints are instructions given by the developer in the query to use a particular type of exectuion plan.

Whenever a query is written then sql comipler creates n number of execution plans and opt for the efficient execution plan while executing the query.

If the hint is given by the developer then the complier use the execution as directed in the hints.

Types of hints:
Table hints
Query hints
Lock hints
View hints
Other hints

Advantage:
May improve the performace
May reduce deadlock

Disadvantage:
May lead complier to used inefficient execution plan
May lead to data inconsistency