Table hints are used to override the default behavior of query optimizer during the data manipulation language (DML) statement. It provides instruction to optimizer how to access the data from a table or view.
It is used with (With Clause).
Below are the common Table Hints.
Ø
Nolock
Ø
ReadPast
Ø
Updlock
Ø
Tablock
Ø
Tablockx
Ø
RowLock
Ø
PageLock
Ø
Xloc
Ø
HoldLock
Ø
Nowait
Ø
Index (Index – name)
Ø
Force seek
Ø
Forcescan
Ø
Read committed
Ø
Read committed lock
Ø
Read uncommitted
Ø
Reapeatableread
Ø
Snapshot
Ø
Keep Identity
Ø
Keep Default
Ø
Ignour_Constraints
Ø
Ignour_Triggers
Ø
Serializable
Ø
NoExpend
