CREATE INDEX

Creates an index on table columns for faster queries.

Basic Syntax

CREATE [UNIQUE] INDEX [IF NOT EXISTS] index_name
ON table_name (column_name [, column_name...]);

Index Type Selection

Oxibase automatically selects the optimal index type based on column data type:

Data Type	Index Type	Best For
INTEGER, FLOAT, TIMESTAMP	B-tree	Range queries, equality, sorting
TEXT, JSON	Hash	Equality lookups, IN clauses
BOOLEAN	Bitmap	Low-cardinality columns

Examples

-- Single-column index
CREATE INDEX idx_user_email ON users (email);

-- Multi-column index
CREATE INDEX idx_order_customer_date ON orders (customer_id, order_date);

-- Unique index
CREATE UNIQUE INDEX idx_unique_email ON users (email);

-- With IF NOT EXISTS
CREATE INDEX IF NOT EXISTS idx_name ON products (name);

See Indexing for detailed documentation.