Page History
...
- Open the IDERA SQL Admin Toolset Launchpad, and then click Index Analyzer.
- Specify the SQL Server instance whose indexes you want to check.
- Check Load Selectivity while loading Statistics to load selectivity statistics now.
- Click Load Statistics.
- View the index data displayed on the Index Statistics tab. To sort the indexes, use the View Options in the right pane.
- To view details about the index columns, click the Column Statistics tab.
- To view index data for a specific table, expand the instance node in the tree pane, and then click the appropriate table.
- 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).
- If you want to save the results, copy the list to clipboard, or save the results as an XML or CSV file.