Add an index to a database table
In this topic, you learn how to add an index to a column of a database table.
You add indices to a column to make searching that column faster. Adding indices is especially useful when working with large tables.
Prerequisites
-
You have configured a table definition.
-
You have added properties to the table definition.
Procedure
-
In the Cockpit, go to Tools and select Table Definition.
-
Open your database table.
-
In the Properties tab, select Indices on the toolbar.
Result: The Indices dialog opens.
-
On the dialog toolbar, select + Add Index.
-
From the dropdown menu on the toolbar, select the column from your table that you want to add an index to.
-
Select + Add Column.
-
Select Apply.
Result
-
You have added an index to a column of the database table.
-
You can see the number of indices added next to Indices on the table toolbar.