Data group properties - Indexes tab

Applications module Data group Properties



Here, indexes for database fields can be defined, which will improve performance when filtering or sorting tables in applications.

Index list

You can find a list of all defined indexes in the left area of the dialog.

Add index
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.

Remove index
Resets an existing index. The index will be removed from the list.

Properties of the selected index

Name

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.

Field column

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.

Add field
The desired field can be selected from the shown drop-down list.

Remove field
The currently selected field is removed from the list.