The Index Maintenance dialog allows you to analyze, create, or edit Archive Indexes for selected Archive Files.
The Number of Files value is the number of files selected in the Select Archive File(s) dialog. Any errors that occur while you are creating or editing an index are displayed at the bottom of the dialog.
Tabs on the Index Maintenance dialog allow you to browse, edit, and create Archive Indexes for the specified Archive Files.
A grid on the Files tab lists information about each Archive File. You can use this tab to provide names of Archive Index Files to be generated for Archive Files that have no indexes.
The server on which the Archive File resides.
The Archive File name, including the path.
The name, including the path, of the Archive Index File associated with the Archive File. If an Archive Index for the Archive File exists, you cannot change the Archive Index File name.
If an Archive File does not have an associated Archive Index, you can type the name of the file to be generated, use the browse button in a selected grid cell to specify a file, or allow the Index Maintenance Utility to create a file name automatically. The new Archive Index File resides on Server.
Right-click the Archive Index File grid column to display the following shortcut menu commands:
Right-click anywhere in the grid, to display the following shortcut menu commands:
This option is available only when the Index Maintenance dialog is opened from the Archive Directory Maintenance dialog.
The Tables tab lists the tables in all Archive Files listed on the Files tab. You can use options at the top of the tab to limit the tables that are listed.
When multiple tables are listed in the grid, use the following options to manage the list.
The name of the table. The format of the table names (one-part, two-part, or three-part) depends on how you choose to group them. For more information about grouping, see Grouping Files.
Use the Indexes tab to view, create, or modify Archive Indexes for one or more Archive Files.
You can use options at the top of the tab to manage the display of tables, indexes, and columns. Select the name of a table to list indexes for the table. The Index grid shortcut menu allows you to add or delete an index.
When multiple Archive Files have been selected for indexing, use the following options to manage the Table list.
Use the following options to manage Archive Indexes for the selected table.
Use the following options to manage the list of columns in the Available Columns grid.
Select the name of a table for which you can analyze, create, or modify Archive Indexes. The selected table name represents all occurrences of the table in the files listed on the Files tab. Index, Index Columns, and Available Columns display information for the selected table. Use the Show Tables that Exist options at the top of the tab to manage the list of tables.
The Index grid lists indexes for the selected table. Click a row in the grid to view or edit an index, and to display the Index Columns and Available Columns lists for an index. Use the Show Indexes that Exist options at the top of the tab to manage the display of indexes.
To create an index, right-click the grid and click Add in the shortcut menu. The utility automatically generates a default name for each index. Default names are in the form “Index_nnn,” where nnn is a sequential three-digit number that provides a unique name for each index. You can use the default name, or edit the name according to your conventions.
Although each occurrence of a table can have no more than 16 indexes at one time, you can define up to 16 indexes for each table without regard to any existing index entries. The Index Maintenance Utility will not add indexes for a table once it has 16 indexes. If more than 16 existing indexes for a table are listed, indexes defined for one or more occurrences of a table do not apply to all occurrences.
Right-click the Index grid to display the following shortcut menu commands:
The Index Columns grid lists columns in the selected index, in the order that they appear in the index. You can drag a column name to change its order in the list.
To add a column to an index, double-click or drag a column name from the Available Columns grid to the appropriate position in the Index Columns grid. To remove a column, use the shortcut menu or double-click or drag a column name to the Available Columns grid.
Right-click the Index Columns grid to display the following shortcut menu commands:
The Available Columns grid lists columns in the table that have not been selected for the index, in the order that they appear in the table. Use the Show Columns that Exist options at the top of the tab to manage which columns are displayed in the grid.
Right-click the Available Columns grid to display the following shortcut menu commands: