Page History

...

To use the Index Analyzer:

1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Index Analyzer.
2. Specify the SQL Server instance whose indexes you want to check.
3. Check Load Selectivity while loading Statistics to load selectivity statistics now.
4. Click Load Statistics.
5. View the index data displayed on the Index Statistics tab. To sort the indexes, use the View Options in the right pane.
6. To view details about the index columns, click the Column Statistics tab.
7. To view index data for a specific table, expand the instance node in the tree pane, and then click the appropriate table.
8. To recalculate the statistics using a sample percentage of rows, click Update Statistics (using Sampling). To recalculate statistics using all rows, click Update Statistics (using Full Scan).
9. If you want to save the results, copy the list to clipboard, or save the results as an XML or CSV file.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...