How to Add Index

1. Click Add Constraint +
2. Select Add Index
3. Select one or more columns
4. (Optional) Configure additional options
5. SQL statement for creating Index is generated automatically

Columns

Select the column(s) to include in the index. For each column you can configure:

• Sort order: ASC or DESC (additional options may be available depending on the database)
• Collation: controls text comparison and ordering
• Single column - standard index
• Multiple columns - composite index (column order matters)

Condition

Defines a partial index. Only rows matching the condition are included in the index.

Access Method

Specifies the index type (e.g., btree, hash). Available options depend on the database.

Tablespace

Specifies where the index is stored. Supported only by some databases (e.g., PostgreSQL).

Included Columns

Additional non-key columns stored in the index. Supported in some databases (e.g., PostgreSQL)

Options

Unique

Ensures all values in the indexed columns are unique.

Nulls Not Distinct

Treats NULL values as equal. (PostgreSQL only)