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