Managing Alternative Indexes

Creating Alternative Indexes

In the Dataset Details page, the Indexes table from the [Columns] section of the [Layout] tab includes the [+ Add Index] button for creating alternative indexes.

On the new row added to the Indexes table, enter the details for the alternative index to create. Then, select the checkbox of the field in the Columns table below to apply the index.

If there is an existing list of candidate alternative indexes, a dropdown box containing those candidates will be provided in the index input box. When you choose from the candidates list, the Index, Offset, Length, and Unique columns will be automatically filled.

he following describes each column item.

Item	Description
Index	Name of the index to create.
Path	Path to the location of the index. Since it is not possible to access an alternative index by using its name at the program level, providing the path is necessary.
Offset	Starting position of the field selected for the index. The offset is automatically set based on the field chosen from the table, and user input is not allowed.
Length	Length of the field selected for the index. The length is automatically set based on the field chosen from the table, and user input is not allowed.
Unique	Option to set the index as unique.

Item

Description

Index

Name of the index to create.

Path

Path to the location of the index. Since it is not possible to access an alternative index by using its name at the program level, providing the path is necessary.

Offset

Starting position of the field selected for the index.
The offset is automatically set based on the field chosen from the table, and user input is not allowed.

Length

Length of the field selected for the index.
The length is automatically set based on the field chosen from the table, and user input is not allowed.

Unique

Option to set the index as unique.

The following describes each function button.

Button	Description
[Save]	Saves the alternative index. If the conditions required for creation are not satisfied, this button remains inactive. The button is disabled in the following case: When the index field is selected in a non-sequential manner.
[Cancel]	Cancels creating the index.

Button

Description

[Save]

Saves the alternative index. If the conditions required for creation are not satisfied, this button remains inactive.
The button is disabled in the following case:

When the index field is selected in a non-sequential manner.

[Cancel]

Cancels creating the index.

Deleting Alternative Indexes

To delete an alternative index, click the [Delete] button at the end of the respective index’s row, on the Indexes table in the [Columns] section of the [Layout] tab in the Dataset Details page.

The default key cannot be deleted. If it is necessary to delete or modify the default key, you will need to delete and then re-create the dataset.