Put equality columns first in many B-tree cases.
Section: Create index patterns
Design for equality then range
sql
sql
-- Often effective
INDEX (tenant_id, status, created_at)
-- Query
WHERE tenant_id = ? AND status = ? AND created_at >= ?Explanation
A strong general pattern is equality predicates first, then range or ordering columns.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Create index patterns