BiteSizedChunks.comLearn one small thing at a time.

Course contentsShow

267What is Connection Pooling
268Connection Creation Cost
269Pool Size Configuration
270Connection Lifecycle in a Pool
271Connection Validation and Stale Connections
272Connection Timeouts and Limits
273Connection Pool Monitoring
274Connection Pool Technologies
275Common Pooling Anti-Patterns
276Why Query Optimization Matters at Scale
277Explain Plans and Query Analysis
278Index Strategy for Large Tables
279Covering Indexes
280Index Merge and Multi-Column Indexes
281Query Rewriting for Performance
282Avoiding N+1 Query Problems
283Pagination at Scale
284Aggregation Query Optimization
285Query Timeout and Statement Limits
286Prepared Statements and Query Caching
287Monitoring Slow Queries
288Why Denormalization?
289Normalized vs Denormalized Schema Design
290When to Denormalize
291Materialized Views
292Embedding vs Referencing in Documents
293Duplicate Critical Fields
294Aggregation Tables
295Maintaining Data Consistency
296Write Amplification Costs
297Denormalization in Practice

267What is Connection Pooling
268Connection Creation Cost
269Pool Size Configuration
270Connection Lifecycle in a Pool
271Connection Validation and Stale Connections
272Connection Timeouts and Limits
273Connection Pool Monitoring
274Connection Pool Technologies
275Common Pooling Anti-Patterns
276Why Query Optimization Matters at Scale
277Explain Plans and Query Analysis
278Index Strategy for Large Tables
279Covering Indexes
280Index Merge and Multi-Column Indexes
281Query Rewriting for Performance
282Avoiding N+1 Query Problems
283Pagination at Scale
284Aggregation Query Optimization
285Query Timeout and Statement Limits
286Prepared Statements and Query Caching
287Monitoring Slow Queries
288Why Denormalization?
289Normalized vs Denormalized Schema Design
290When to Denormalize
291Materialized Views
292Embedding vs Referencing in Documents
293Duplicate Critical Fields
294Aggregation Tables
295Maintaining Data Consistency
296Write Amplification Costs
297Denormalization in Practice

← System Design

Lesson 281 of 1,919·8. Database Performance OptimizationPro lesson

Query Rewriting for Performance

Transforming semantically equivalent queries into forms that execute faster, like replacing subqueries with joins.

This lesson is for subscribers

You've completed the free preview. Subscribe to unlock every lesson in every course.

See pricing Back to course