| Description |
xvii, 310 pages : illustrations ; 24 cm |
| Contents |
1. Introduction -- 2. Table and index organization -- 3. SQL processing -- 4. Deriving the ideal index for a SELECT -- 5. Proactive index design -- 6. Factors affecting the index design process -- 7. Reactive index design -- 8. Indexing for table joins -- 9. Star join considerations -- 10. Multiple index access -- 11. Indexes and reorganization -- 12. DBMS-specific indexing restrictions -- 13. DBMS-specific indexing options -- 14. Optimizers are not perfect -- 15. Additional estimation considerations -- 16. Organizing the index design process |
| Summary |
"This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design." "This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware."--BOOK JACKET |
| Bibliography |
Includes bibliographical references and index |
| Subject |
Relational databases.
|
| Author |
Leach, Mike, 1942-
|
| ISBN |
9780471719991 : |
|
0471719994 (hbk.) |
|
