Book
SQL実践入門
ミック
Summary
実行計画（EXPLAIN）の読み解きから、Nested Loops / Hash Join / Sort Merge の選択基準、 暗黙型変換による性能劣化、ウィンドウ関数による N+1 解消まで、SQL を高速かつ可読に書くための 実践的指南。図解で内部アルゴリズムを示し、なぜ速い書き方が速いのかを構造的に理解できる。
Target Readers
- SQL の遅さに悩むエンジニア
- 実行計画を読んでクエリを改善できるようになりたい開発者
Tags
Colophon
- Publisher
- 技術評論社
- ISBN
- 978-4774173016
- Published
- Apr 2015
- List price
- ¥2,838incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
SQL 第2版
ミック
Reason: After you can write correct SQL, the next lens is reading the execution plan (EXPLAIN) to understand why a query is slow. This book starts tuning from the execution plan, so reading it right after the basics grows you from 'can write SQL' to 'can write fast SQL'.
Next Books
- Recommended
失敗から学ぶRDBの正しい歩き方
曽根壮大
Reason: Once you study query tuning and index design, you see that many performance problems trace back to early schema and operational decisions. This Japanese book on RDB pitfalls (失敗から学ぶRDBの正しい歩き方) covers operational anti-patterns—soft deletes, caching, idempotency—lifting your view above optimizing individual SQL statements.
Sources
- Recommended
SQLパフォーマンス詳解
Markus Winand
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
プログラマのためのSQL 第4版
Joe Celko
Reason: With a tuning foundation grounded in execution plans, Celko's advanced idioms land more deeply—you grasp not just the syntax but why a given form performs well. A supplementary path for re-examining declarative complex queries such as recursive CTEs from both expressiveness and performance.