Test with FORCE INDEX

sql

SELECT id
FROM orders FORCE INDEX (idx_orders_status_created_at)
WHERE status = 'paid'
ORDER BY created_at DESC
LIMIT 50;

Explanation

Useful for testing, but avoid relying on it as the first fix for poor design.

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 Verify usage

See whether the optimizer chooses your index.

Open In sheetsqlsame section

Help the optimizer make better choices after major data changes.

Open In sheetsqlsame section

Support a filter plus order-by pattern.

Open In sheetsql1 tag match

Practical route for function-based searches.

Open In sheetsql1 tag match

Test an index without making it visible to the optimizer by default.

Open In sheetsql1 tag match

Hide or re-enable an index without dropping it.

Open In sheetsql1 tag match