"I recommend this book to all those who have anything to do with database performance. It is a must-read for all database administrations, database designers, performance-tuning specialists, and application programmers…" (Computing Reviews.com
, November 20, 2005)
From the Back Cover
Improve the performance of relational databases with indexesdesigned for today's hardware
Over the last few years, hardware and software have advancedbeyond all recognition, so it's hardly surprising that relationaldatabase performance now receives much less attention.Unfortunately, the reality is that the improved hardware hasn'tkept pace with the ever-increasing quantity of data processedtoday. Although disk packing densities have increased enormously,making storage costs extremely low and sequential read very fast,random reads are still painfully slow. Many of the old designrecommendations are therefore no longer validthe optimalpoint of indexing has come a long way. Consequently many of the oldproblems haven't actually gone awaythey have simply changedtheir appearance.
This book provides an easy but effective approach to the designof indexes and tables. Using lots of examples and case studies, theauthors describe how the DB2, Oracle, and SQL Server optimizersdetermine how to access data, and how CPU and response times forthe resulting access paths can be quickly estimated. This enablescomparisons to be made of the various designs, and helps you chooseavailable choices for the most appropriate design.
This book is intended for anyone who wants to understand theissues of SQL performance or how to design tables and indexeseffectively. With this title, readers with many years of experienceof relational systems will be able to better grasp the implicationsthat have been brought into play by the introduction of newhardware.