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.
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.
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