Normal view MARC view ISBD view

Lahdenm�aki, Tapio.

Relational database index design and the optimizers : DB2, Oracle, SQL server et al. / Tapio Lahdenm�aki, Michael Leach. - Hoboken, N.J. : John Wiley & Sons, �2005. - 1 online resource (xvii, 310 pages) : illustrations

Includes bibliographical references and indexes.

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.

Use copy

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.


Electronic reproduction.
[Place of publication not identified] :
HathiTrust Digital Library,
2010.


Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
http://purl.oclc.org/DLF/benchrepro0212

ISBN: 0471719994 9780471719991 0471721379 9780471721376 0471721360 9780471721369 1280276614 9781280276613 9786610276615 6610276617 0470247053 9780470247051

Standard No.: 10.1002/0471721379 doi

Source: OverDrive, Inc. http://www.overdrive.com 137FE088-805C-43A1-9D79-CED72B9C62CB OverDrive, Inc. http://www.overdrive.com

Subjects--Topical Terms:
Relational databases.
Bases de donn�ees relationnelles.
COMPUTERS--Programming Languages--SQL.
Relational databases
Relationele databanken.
Indexeren.

Subjects--Index Terms: Computer Science.

LC Class. No.: QA76.9.D3 / L335 2005eb

Dewey Class. No.: 005.75/65