Table Indexes

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 in 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 string is added to the end of the list, in which specify the following attributes:

NOTE. If ClickHouse DBMS is selected on the Properties page, unique key is replaced with sorting key. Sorting key determines data storage order and does not depend on the Primary Key checkbox data. If primary key is not set, sorting key is used as a primary key.

To change the number of displayed attributes, click the Settings button and select or deselect the checkbox next to attribute name.

The already created indexes can be edited 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 in different fields or groups of fields, in this case it is reasonable to create several indexes.

To create an index:

To edit the selected index, click the Edit button, in the Index Properties dialog box that opens make the required changes.

To delete the current index, click the Delete button.

Index Properties

The Index Properties dialog box opens on creating and editing index:

In the dialog box that opens determine the following attributes:

See also:

View