PARTIAL INDEX

PARTIAL INDEX is a SQL statement in the Indexes category. Index that only includes rows matching a WHERE condition. Smaller and faster. PostgreSQL-only. The syntax is CREATE INDEX idx_name ON table (col) WHERE condition;. It returns partial index. A typical example: CREATE INDEX idx_active_users ON users (email) WHERE is_active = TRUE; -- Only indexes active users — smaller index SELECT * FROM users WHERE is_active = TRUE AND email = 'test@test.com'; -- Uses the partial index efficiently A close relative is CREATE INDEX, which creates an index on one or more columns to speed up query performance. A close relative is DROP INDEX, which removes an existing index from a table. A close relative is COMPOSITE INDEX, which an index on multiple columns. Column order matters — queries use leftmost prefix. More about this category: Database indexes — CREATE INDEX, UNIQUE INDEX, COMPOSITE INDEX, DROP INDEX.