Archive Index Tab

Archive Index information expedites the identification of archived data when browsing an Archive File, or restoring data in an Archive File.

Archive can search an index more quickly than it can search an entire Archive File. Use the Archive Index tab to define one or more indexes of values in one or more columns to use when searching for an Archive File that contains specific data.

archive index tab where you can select columns to be used as indexes

You can define indexes in three ways:

Index Name

You can create up to 16 indexes for each table in an Archive File. Archive automatically generates a name for each index. You can use this default name, or edit the name according to your conventions. The generated names are in the form “Indexn” where n is a sequential number that provides a unique name for each index. After you create an index, you can right-click the index name and select ADD from the shortcut menu to create additional indexes. If you create more than one index, click the arrow icon column to display the list of Index Columns for the corresponding Archive Index name.

Status

Indicates the status of the Archive Index:

blank
Index was defined prior to the current session.
New
Database or relationship index was defined during the current session and is new to the list.

Index Columns

Double-click a column name to move it from the Available Columns list to the Index Columns list. (You can also drag column names between lists.)

Available Columns

The names of columns in the selected table.

Note: Large Object (LOB) columns are not available for use as Archive Index columns.

Archive Index Specifications Identified

An Archive Index icon archive index icon in the Table Specifications column on the Access Definition Editor table List indicates that Archive Index specifications are defined for the table.