SQL Performance Explained | Data Engineering & Databases | Oh My Learning

01 How the Optimizer Chooses Access Paths 8 min read junior drafted 02 B-Tree Index Structure and Lookup Mechanics 8 min read junior drafted 03 Selectivity, Cardinality Estimates, and Predicate Shape 8 min read mid drafted 04 Multi-Column Indexes and Left-Prefix Behavior 8 min read mid drafted 05 Covering Indexes and Index-Only Retrieval 7 min read mid drafted 06 Join Execution and Indexing Foreign-Key Relationships 8 min read mid drafted 07 ORDER BY, GROUP BY, and Avoiding Expensive Sorts 8 min read mid drafted 08 Pagination Patterns: OFFSET Pitfalls and Keyset Pagination 8 min read mid drafted 09 Clustering Effects and Physical Row Ordering Trade-offs 9 min read senior drafted 10 Reading Execution Plans and Validating Performance Hypotheses 8 min read mid drafted