Reset Filters
Branch: 松江九亭镇

Cover is for reference only

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:
Bibliographic Details
Main Authors: Lahdenmäki, Tapio
Corporate Authors: John Wiley & Sons
Group Author: Leach, Mike, 1942
Published:
Literature type: Electronic eBook
Language: English
Subjects:
Relational databases
Bases de données relationnelles
COMPUTERS > Programming Languages > SQL
Relationele databanken
Indexeren
Computer Science.
Electronic books
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.

Related Book Recommendations