Example covering query

sql

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

Explanation

Covering or index-only strategies are strongest when the query reads only columns present in the index.

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

Avoid expensive sorts when possible.

Open In sheetsqlsame section

Store extra columns for index-only scans.

Open In sheetsql1 tag match

Index a common lookup column.

Index fields that are commonly used together.

Put equality columns first in many B-tree cases.