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.

Procedure

  1. In the Cockpit, go to Tools and select Table Definition.

  2. Open your database table.

  3. In the Properties tab, select Indices on the toolbar.

    Result: The Indices dialog opens.

  4. On the dialog toolbar, select + Add Index.

  5. From the dropdown menu on the toolbar, select the column from your table that you want to add an index to.

  6. Select + Add Column.

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