Good book on index design

I am an experienced software developer who has designed some fairly sophisticated databases. However, I have not had a lot of training regarding index design and have had DBAs to back me up in case I needed better indexing. Now I don't have a DBA to fall back on and I am having some performance issues on a specific report in one of my databases. How do I resolve the problem? By carefully reading this book.

Index design is not easy, especially when there are many tables involved, joined together in a variety of interesting ways. However, this book helped me understand the core issues of index design. It also helped me understand how to estimate the cost of different indexing strategies. Throughout the book, the authors did a good job of being consistent in their treatment of the topic. I am armed, ready to tackle my report performance issue!

Other Reviews

• Excellent book to build mental estimate of cost of queries and best indexes
• Good book on index design
• A book of choice... or may be a book of SELECT ?
• Diving deep into expert knowledge