Preface — Why is indexing a development task? Anatomy of an Index — What does an index look like? The Leaf Nodes — A doubly linked list The B-Tree — It’s a balanced tree Slow Indexes, Part I — Two ingredients make the index slow The Where Clause — Indexing to improve search performance The Equals Operator — Exact key lookup Primary Keys — Verifying index usage Concatenated Keys — Multi-column inde
![The annotated table of contents](https://cdn-ak-scissors.b.st-hatena.com/image/square/b5dc1b986d0491a7f56531a11754450af3f0424a/height=288;version=1;width=512/https%3A%2F%2Fuse-the-index-luke.com%2Fstatic%2Futil_squirrel.og.fMeqdSQq.png)