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 284 of 1,919·8. Database Performance OptimizationPro lesson

Aggregation Query Optimization

Strategies for GROUP BY, COUNT, and SUM queries including covering indexes and materialized aggregates.

This lesson is for subscribers

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

See pricing Back to course