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

Procedure

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

  2. Open your database table.

  3. Navigate to the Properties tab and click Indices on the toolbar.

    Result: The Indices dialog opens.

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

    table definition indices add

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

  6. Click + Add Column.

    table definition indices add column

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

Next steps