View index scan results

When the index scan is over, all scanned indexes appear in the Index Manager document. The document is divided into two sections:

• Action required – Lists all indexes that require maintenance according to the preset index analysis criteria.
• No action required – Lists all indexes that do not require maintenance, according to the preset index analysis criteria.

Both sections provide exhaustive details for the scanned indexes, including index name, size and owner, fragmentation volume, and reason for fragmentation.

Manage indexes

Scan results can be grouped by column and filtered with default or custom filters. You can also use the search box to find indexes that meet the search string.

Filter indexes

1. In the Index Manager document, navigate to the Action required section.

2. Click the filter glyph on a column header.

3. Select a filter from the list or create a custom filter.

Sort indexes

To sort indexes in the document or to change the sort order, click the header of a column.

To assign a secondary sorting, click another column header while holding down the Shift key. You can set as many sorting columns as you need. To stop sorting on a specific column, click it while holding the Ctrl key.

To clear column sorting, click the column header again.

The current sort order of a column is indicated by the sort glyph (a small arrow displayed at the column header’s right edge). If data is sorted in ascending order, the sort glyph represents an up-arrow. When sorting in descending order, the sort glyph is displayed as a down-arrow. If the column isn’t sorted, the sort glyph is hidden.