Indexes

In this section, you can manage indexes for your table to improve query performance. You can add new indexes or delete existing ones using the + Add and X Delete Selected buttons.

You can configure the following for an index:

• Schema: The name of the schema under which the index is created.

• Name: The name of the index. You can edit the name by double-clicking the cell.

• Type: The type of index, such as UNIQUE, NON-UNIQUE, or BITMAP.

• Tablespace: Specifies the tablespace where the index is stored.

• Available Columns and Selected Columns: Select one or more columns to be included in the index. Use the Available Columns list and arrow buttons to move columns to the Selected Columns list and organize their order.

• Expression: Allows you to specify the expression that defines the index logic.

Once your index configuration is complete, click Apply to save your changes.