“Use the Index, Luke!: A guide to database performance” is a free online SQL indexing and tuning book by Markus Winand. This book is for developers; it avoids unnecessary details about database internals.
Book Description
This book covers everything developers need to know about indexes—and nothing more. To be more precise, the book covers the most important index type only: the B-Tree index. The B-Tree index works almost identical in various databases. The book uses the terms of the Oracle database only, but the principles apply to other databases as well. Side notes provide relevant information for MySQL, PostgreSQL and Microsoft SQL Server.
The structure of the book is tailor-made for developers; most of the chapters correspond to a specific part of an SQL statement.
Table of Contents
- Anatomy of an Index
- The Where Clause
- Testing and Scalability
- The Join Operation
- Clustering Data
- Sorting and Grouping
- Partial Results
- Insert, Delete and Update
- To Be Continued
- Execution Plans
- Myth Directory
- Glossary
- Example Schema