Use a covering index pattern

sql

CREATE INDEX idx_orders_customer_created
ON orders (customer_id, created_at);

Explanation

Composite indexes can satisfy multiple parts of a query pattern.

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 Index Strategy

Speed up frequent equality or range predicates.

Open In sheetsqlsame section

Preserve index usability in predicates.

Open In sheetsqlsame section

Inspect the execution plan for a SELECT statement.

Paginate by a stable cursor instead of a large OFFSET.

Detect repeated values that should be unique.

Run a query and collect timing or actual row information where supported.