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

• Main Author: Lahdenmaki, Tapio
• Corporate Author: John Wiley & Sons
• Other Authors: Leach, Mike 1942-
• Format: Electronic Book
• Language: English
• Published: Hoboken, N.J. John Wiley & Sons c2005
• Subjects: Σχεσιακές βάσεις δεδομένων

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