sys.dm_db_missing_index_details

Description

Returns detailed information about missing indexes. In Azure SQL Database, dynamic management views cannot expose information that would impact database containment or expose information about other databases the user has access to. To avoid exposing this information, every row that contains data that doesn’t belong to the connected tenant is filtered out. Identifies a particular missing index. The identifier is unique

Syntax

sys.dm_db_missing_index_details