Cover Image

Relational database index design and the optimizers : DB2, Oracle, SQL server et al. /

Show other versions (1)
Bibliographic Details
Main Author: Lahdenmäki, Tapio
Corporate Author: John Wiley & Sons
Other Authors: Leach, Mike, 1942-
Format: eBook
Language:English
Published: Hoboken, N.J. : John Wiley & Sons, [2005]
Subjects:
Relational databases.
Computer Science.
Electronic books.
Online Access:Connect to the full text of this electronic book
Table of 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.