Create composite index

sql

CREATE INDEX idx_orders_customer_created
ON orders (customer_id, created_at);

Explanation

Column order matters in composite indexes.

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 Constraints and Indexes

Add an index to improve lookup performance.

Open In sheetsqlsame section

Mark a column as the main row identifier.

Open In sheetsqlsame section

Ensure a column or column set stays unique.

Open In sheetsqlsame section

Restrict column values with a boolean rule.

Open In sheetsqlsame section

Define a new table with columns and constraints.

Add a single row to a table.