Table Hints (Transact-SQL)
Table hints override the default behavior of the query optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query processing operation such as a table scan or index seek, or other options.
WITH ( <table_hint> [ [ , ]…n ] )
<table_hint> ::=
[ [...]
Filed under: Table Hints | Tagged: and NOEXPAND, FASTFIRSTROW, MSSQL Table Hints, NOLOCK, NOWAIT, PAGLOCK, READCOMMITTED, READPAST, READUNCOMMITTED, REPEATABLEREAD, ROWLOCK, SERIALIZABLE, SQL Locks, SQL Tips, SQL Tricks, Table Hints (Transact-SQL), TABLOCK, TABLOCKX, UPDLOCK, XLOCK | Leave a Comment »
