Rules Hub
Coding Rules Library
← Back to all rules
Rule priority, scope & exceptions
Use this to align rules with the senior-level structure (P0/P1/P2, scope, exceptions/tradeoffs).
backend ruleP2universalStack: sql
sqlperformancequeriesindexing
Place the most selective condition first in a WHERE clause
Lead with the cheapest, most discriminating predicate (an indexed id) before expensive comparisons for better query efficiency.
PR: vinify-backend · org-mining-deep-2026-06Created: Jun 17, 2026
Bad example
Old codesql
| 1 | WHERE image_url = '...' AND main_profile_id = 5 |
Explanation (EN)
Objašnjenje (HR)
Good example
New codesql
| 1 | WHERE main_profile_id = 5 AND image_url = '...' |
Explanation (EN)
Objašnjenje (HR)