Indexing & Query Optimization
Deep dive into database indexes — B-Tree, hash, covering, composite — and strategies to analyze and optimize slow queries.
Deep dive into database indexes — B-Tree, hash, covering, composite — and strategies to analyze and optimize slow queries.
How databases store and retrieve data — B+ trees, LSM trees, heap files, InnoDB vs MyISAM, WAL, and buffer pools.