Export (0) Print
Expand All

Hints

SQL Server 2000

This table lists the options available for join hints, query hints, and table hints in Microsoft® SQL Server™ 2000.

Hint type
Option

Description
Default
setting
Join LOOP  |  HASH
|  MERGE  |  REMOTE
Specifies the strategy to use when joining the rows of two tables. Chosen by SQL Server.
Query { HASH | ORDER } GROUP Specifies whether hashing or ordering is used to compute GROUP BY and COMPUTE aggregations. Chosen by SQL Server.
Query { MERGE | HASH |
CONCAT }  UNION
Specifies the strategy to use for all UNION operations within the query. Chosen by SQL Server.
Query FAST integer Optimizes the query for retrieval of the specified number of rows. No such optimization.
Query FORCE ORDER Performs joins in the order in which the tables appear in the query. Chosen by SQL Server.
Query ROBUST PLAN Creates a plan that accommodates maximum potential row size. Chosen by SQL Server.
Table FASTFIRSTROW Has the same effect as specifying the FAST 1 query hint. No such optimization.
Table INDEX = Instructs SQL Server to use the specified indexes for a table. Chosen by SQL Server.
Table HOLDLOCK 
|  SERIALIZABLE    
|  REPEATABLEREAD 
|  READCOMMITTED 
|  READUNCOMMITTED
|  NOLOCK
Specifies the isolation level for a table. Defaults to a transaction isolation level.
Table ROWLOCK
|  PAGLOCK
|  TABLOCK
|  TABLOCKX
|  NOLOCK
Specifies locking granularity for a table. Chosen by SQL Server.
Table READPAST Skips locked rows altogether. Wait for locked rows.
Table UPDLOCK Takes update locks instead of shared locks. Cannot be used with NOLOCK or XLOCK. Take shared locks.
Table XLOCK Takes an exclusive lock that will be held until the end of the transaction. Cannot be used with NOLOCK or UPDLOCK. Chosen by SQL Server.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft