Rule Performance

Index Query Columns

Add database indexes for columns used in WHERE and JOIN clauses

performancedatabaseindexing
CLAUDE.md

Add database indexes for columns used in WHERE, JOIN, and ORDER BY clauses. Review query plans for full table scans. Don’t over-index — each index slows down writes.

Copy this block into your CLAUDE.md or agent config file to enforce it in your workflow.

get crystl