The Indexes page is used to set a list of table indexes. Indexing provides quick search and selection of values based on indexed fields.
NOTE. Indexes can be created only for a saved view.
Search is often executed by different fields or groups of fields, in this case it is reasonable to create several indexes.
To create an index, click the Add button. A line is added to the end of the list, in which specify the following attributes:
Name. Enter index name. The default name is Index.
Identifier. Enter a unique identifier of the index in the view indexes list (only Latin letters, numbers, and the "_" character can be used, spaces are not allowed). The default identifier: <View identifier>_INDEX<Index number>.
Index Fields. Select fields in the drop-down list. The list contains all view fields that can be added to the index field. If the index consists of several fields, the search is executed from the top of the list to the bottom.
Primary Key. Select the checkbox if the index is primary. When the checkbox is selected, the Unique checkbox is selected automatically.
Unique. Select the checkbox is the index is unique. A unique index unambiguously determines each record. 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.
To change the number of displayed attributes, click the Settings button and select or deselect the checkbox next to attribute name.
Editing of already created indexes is executed in the indexes list.
To delete one or several indexes, select them and click the Delete button. A confirmation dialog box opens.
To finish the wizard, click the Save button.
Search is often executed by different fields or groups of fields, in this case it is reasonable to create several indexes.
To create an index:
Click the Add button.
Double-click the index list area.
To edit the selected index, click the Edit button, in the Index Properties dialog box that opens enter the required changes.
To delete the current index, click the Delete button.
The Index Properties dialog box opens on creating and editing an index:
Use this dialog box to determine the following attributes:
Name. Index name.
Identifier. A unique identifier of the index in the table indexes list (only Latin letters, numbers, and the `_` symbols 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 of fields included in the index. If the index consists of several fields, the search is executed from the top of the list to the bottom. Use Drag&Drop mechanism to add fields from the Table Fields list to the Index Fields list.
Primary Key. The checkbox is selected if index is primary.
Unique. The checkbox is selected if index is 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 built on the basis of fields with empty values, because in this case unambiguity is lost.
See also: