Data group properties - Indexes tab
This tab is available if the expert options
have been activated. Here, indexes for database fields can be defined, which will
improve performance when filtering or sorting tables in applications.
If the data group contains foreign keys
, indexes will already
have been created here - one index for all primary keys and one index per
reference. These indexes cannot be edited via this dialog or changed - apart from the
index names. If a reference from the data group is deleted, the
corresponding index is deleted automatically.
You can find a list of all defined indexes in the left area of the dialog.
Creates a new index. The name of the index will be generated automatically
from the name of the current data group and an incremental number.
Resets an existing index. The index will be removed from the list.
Properties of the selected index
The index name of the currently selected index is shown here and can be edited.
Index is unique
If the field (or fields) in the "Fields" column
contains unique values, the "Index is unique"
setting can be selected to improve the performance when filtering or sorting.
List of fields that are selected for the index.
Sorting order column
For each field you can define whether the index should be in ascending
or descending order.
The desired field can be selected from the shown drop-down list.
The currently selected field is removed from the list.