The Table Indexes page enables the creation of a table index list. Indexing ensures quickly search and selection of values, and maintaining of unique values for certain fields. A search is often executed by different fields or groups of fields. If this is the case, it is advisable to create multiple indexes.
To create an index:
Click the Add button.
Double-click the index list area.
The Index Properties dialog box opens.
To edit the selected index, click the Edit button, open the Index Properties dialog box and make required changes.
To delete the current index, click the Delete button.
Define the following attributes:
Name. Index name.
Identifier. A unique identifier of the index in the list of table indexes (only Latin letters and numbers can be used; spaces are not allowed).
Table Fields. The list of all table fields that can be added to the index field.
Index Fields. The list contains fields included into index and shows their order. If the index consists of several fields, the search is executed from the top of the list to the bottom. Use Drag&Drop mechanism, or double left click required index to add fields from the Table Fields list to the Index Fields list.
Primary Key. Select the checkbox if the index is a primary one.
Unique. Selecting the checkbox makes the index unique. A unique index unambiguously determines each record. The first of the unique indexes is the primary index. When a unique or a primary index is created, remember that these indexes cannot be based on the fields that can have empty values, because in this case unambiguity is lost.
See also: