Create a composite index

sql

CREATE INDEX idx_orders_user_status_created ON orders (user_id, status, created_at);

Explanation

Composite indexes can accelerate queries that filter by the leading columns.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing indexes

Add an index for a frequently filtered column.

Open In sheetsqlsame section

Display index metadata for a table.

Open In sheetsqlsame section

Remove an index that is unused or harmful.

Open In sheetsqlsame section

View the optimizer's execution plan.

Execute the query and include actual timing information.

Update optimizer statistics for a table.