Schema
Indexes
View and manage database indexes.
Viewing Indexes
Indexes are listed under each table in the schema browser. Each index shows:
- Index name
- Indexed columns
- Index type (B-tree, Hash, GiST, GIN, etc.)
- Unique constraint indicator
Creating Indexes
Use the Table Designer or run a query:
CREATE INDEX idx_users_email ON users (email);
CREATE UNIQUE INDEX idx_users_username ON users (username);Index Types (PostgreSQL)
| Type | Use Case |
|---|---|
| B-tree | Default, general-purpose |
| Hash | Equality comparisons only |
| GiST | Geometric and full-text search |
| GIN | Array and JSONB containment |
| BRIN | Large, naturally-ordered tables |