Query Performance — Study Resources & PYQs
Curated resources, past papers and PYQs for Query Performance.
Study resources
- N+1 Query Problem with JPA and Hibernate (Article) — Baeldung's clear explanation of the N+1 query problem and how to fix it.
- JPA N+1 Query Problem Explained (Video) — Covers avoiding common JPA performance pitfalls.
- Using EXPLAIN (Article) — The official PostgreSQL documentation on reading query plans to diagnose performance.
- SQL Query Optimization Explained (Video) — A practical walkthrough of diagnosing and fixing slow SQL queries.