sys.dm_db_missing_index_columns

Description

Returns information about database table columns that are missing an index. is a dynamic management function. An integer that uniquely identifies a missing index. It can be obtained from the following sys.dm_db_missing_index_details (Transact-SQL) sys.dm_db_missing_index_groups (Transact-SQL) How the column is used by the query.

Syntax

sys.dm_db_missing_index_columns

Examples

Example 1

sys.dm_db_missing_index_columns

Example 2

sqlserver_start_time

Example 3

Address

Example 4

sys.dm_db_missing_index_columns