Support ORDER BY with an index

sql

SELECT id, created_at
FROM orders
WHERE status = 'paid'
ORDER BY created_at DESC
LIMIT 50;

Explanation

An index on `(status, created_at DESC)` may let the planner filter and return rows in the needed order.

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 Covering and ordering

Query only indexed columns when possible.

Open In sheetsqlsame section

Index a common lookup column.

Open In sheetsql1 tag match

Index fields that are commonly used together.

Open In sheetsql1 tag match

Store extra columns for index-only scans.

Put equality columns first in many B-tree cases.