Add indexes on columns that appear in join conditions, filters, and sort clauses.
Why This Matters
Unindexed predicates force full table scans that degrade sharply as the table grows.
Related Rules
Catch this automatically on every PR
BeforeMerge scans your pull requests against this rule and dozens more. Get actionable feedback before code ships.