# Reference

Check:
- indexes on FK and common filter/sort paths
- over-indexing on write-heavy tables
- trigger recursion or cascade chains
- stale denormalized data maintenance
- lock/contention risk
- trigger timing and transaction scope