To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases.
For this purpose, display these statistics of indexes:
Also, display these statistics of index columns:
The Index Analyzer tool of SQL Admin Toolset displays indexes contained in a specific table, and displays index properties and performance statistics across instances of SQL Server.This is how easy it is:
Watch the video for more details:
Try this yourself by downloading the free 14-day trial of SQL Admin Toolset.