Relational database index design and the optimizers DB2, Oracle, SQL server et al. /
Improve the performance of relational databases with indexes designed for today's hardwareOver the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention.
Saved in:
Main Authors: | |
---|---|
Corporate Authors: | |
Group Author: | |
Published: |
|
Literature type: | Electronic eBook |
Language: | English |
Subjects: | |
Online Access: |
http://onlinelibrary.wiley.com/book/10.1002/0471721379 |
Summary: |
Improve the performance of relational databases with indexes designed for today's hardwareOver the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. |
Carrier Form: | 1 online resource (xvii, 310 pages) : illustrations |
Bibliography: | Includes bibliographical references and indexes. |
ISBN: |
0471719994 9780471719991 0471721379 9780471721376 0471721360 9780471721369 |
Index Number: | QA76 |
CLC: | TP311.132.3 |
Contents: | Table and index organization -- SQL processing -- Deriving the ideal index for a select -- Proactive index design -- Factors affecting the index design process -- Reactive index design -- Indexing for table joins -- Star join considerations -- Multiple index access -- Indexes and reorganization -- DBMS-specific indexing restrictions -- DBMS-specific indexing options -- Optimizers are not perfect -- Additional estimation considerations -- Organizing the index design process. |