CREATE INDEX
command
Creates an index on a table column to speed up query performance.
Syntax
CREATE INDEX index_name ON table (column);
Example
sql
-- Basic index
CREATE INDEX idx_name ON users (name);
-- Unique index
CREATE UNIQUE INDEX idx_email ON users (email);
-- Composite index
CREATE INDEX idx_cat_date ON posts (category_id, created_at DESC);
-- Full-text index
CREATE FULLTEXT INDEX idx_content ON posts (title, body);