The Table Indexes Page: Table

The Indexes page is used to set a list of table indexes. 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 a new index:

In the web application click the Add button. A new string is added to the index list.
In the desktop application:

Click the Add button.
Double-click the empty area of the index list.

The Index Properties dialog box opens:

All boxes are set to default values.

Set index attributes:

Name. Enter index name. The default name is Index.
Identifier. Enter unique identifier of the index in the list of table indexes (only Latin letters and numbers are allowed; spaces are not allowed). The default identifier: <Table identifier>_INDEX<Number>.
Table Fields. The list of all table fields that can be added to the index field. It is available only in the desktop application.
Index Fields. In the web application, select fields in the drop-down list, or in the desktop application add fields from the Table Fields list by double-click or by dragging fields. The list contains all table 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 is 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 displayed properties in the web application, select or deselect the required properties in the drop-down menu of the Settings button.