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