Book
SQLパフォーマンス詳解
Markus Winand
Summary
B-Tree インデックスの内部構造、複合インデックスのカラム順、WHERE / ORDER BY 句との関係を Oracle / SQL Server / PostgreSQL / MySQL の差異を含めて精緻に解説した世界的名著。 「とりあえずインデックスを張る」発想を覆し、ディスク I/O の観点から計算的に パフォーマンスを設計する力を養う。たった 200 ページに濃密な知識が凝縮されている。
Target Readers
- インデックス戦略を論理的に設計したい中・上級エンジニア
- 実行計画を読んで SQL を最適化できるようになりたい開発者
Tags
Colophon
- ISBN
- 978-3950307849
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
達人に学ぶSQL徹底指南書 第2版
ミック
Reason: Once you can write applied SQL, you want to understand why a query is fast or slow from the internal structure of indexes. Markus Winand's 'SQL Performance Explained' builds index design up from how B-Trees work, connecting the way you write SQL with how fast it runs.
- Recommended
SQL実践入門
ミック
Reason: After learning to read execution plans in the practical intro, dig deeper into the internal structure of indexes themselves with Winand's 'SQL Performance Explained'. Understanding index structure clarifies why a plan chooses a given access path, raising the resolution of your tuning.
- Related
達人に学ぶDB設計徹底指南書 第2版
ミック
Reason: After learning normalization-centric logical design, this is a supplementary path to understanding how that design rebounds on physical performance. Reading Winand's 'SQL Performance Explained' reveals how table design and key choices govern index efficiency, giving physical grounding to your logical-design decisions.
Next Books
- Recommended
PostgreSQL徹底入門 第4版
近藤雄太, 正野裕大, 坂井潔, 鳥越淳, 笠原辰仁, 石井達夫
Reason: After grasping RDBMS-agnostic index theory in 'SQL Performance Explained', verify how it is implemented in a concrete product via the Japanese PostgreSQL book (PostgreSQL徹底入門). Touching PostgreSQL-specific index types—B-Tree, GiST, GIN, BRIN—and transaction mechanisms lands the abstract theory onto a concrete implementation.
- Recommended
Database Internals
Alex Petrov
Reason: After understanding the internals of B-Tree indexes in 'SQL Performance Explained', broaden your view with Alex Petrov's 'Database Internals' to the LSM-Trees and various storage engines beyond the B-Tree. Comparing data structures with different read/write characteristics cultivates judgment for choosing a database engine.