Index Performance Statistics & Analysis

Index performance analysis covers the statistics of index usage, such as index size, table scan, least-frequently-used indexes, and index updates, and indicates missing indexes and suggestions.

1. Select Database and Performance Indicators

Based on a single database, index performance analysis can be provided for statistics of all databases by default, and users can also select one or several databases for analysis.

2. Missing Indexes and Suggestions

It is recommended to obtain missing indexes according to the Microsoft system in combination of the manual judgment of DBA or related developers.

The usage mode of each column is as follows: create index on

(,) include(), with the column of high selectivity placed before

See the detailed use and limits of missing index information in Microsoft Official Document.