Archive Index information expedites the identification
of archived data when you browse an Archive File or restore 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 you search for an Archive File that contains
specific data.
Note: A table can include up to 64 indexes. Creating a large number of
indexes can affect archive processing.
You can define indexes in three ways:
- Select Add
Relationship Indexes from the Table Specifications dialog Tools menu
to automatically generate indexes for all tables in the Access Definition, based
on the relationships between the tables.
- For the current table, right-click
and select Add Database Indexes to add all
columns with database indexes to the current list, or select Replace
with Database Indexes to replace the current list with
a list of columns that have database indexes.
- For the current table, list columns
manually by dragging one or more column names from Available
Columns list to Index Columns list.
Index Name
You can create up to 64 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 more indexes. If you create more
than one index, click the
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 before 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 also can 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
in the Table Specifications
column on the Access Definition Editor table
list indicates that Archive Index specifications are defined for the
table.