sys.dm_exec_valid_use_hints (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns USE HINT supported hint names. It lists one hint name per row.
Use this DMV to see the list of all supported hints under the USE HINT notation.
| Column Name | Data Type | Description |
|---|---|---|
| name | sysname | The name of the hint. |
See Query Hints for descriptions of each hint.
Introduced in SQL Server 2016 (13.x) SP1.
See Also
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for