Relational database index design and the optimizers
Lahdenmaki, Tapio
Relational database index design and the optimizers DB2, Oracle, SQL server et al. [electronic resource] Tapio Lahdenmaki, Michael Leach - Hoboken, N.J. John Wiley & Sons c2005 - xvii, 310 σ. ill
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
0471719994 9780471719991 0471721379 9780471721376
Σχεσιακές βάσεις δεδομένων
005.756 5
Relational database index design and the optimizers DB2, Oracle, SQL server et al. [electronic resource] Tapio Lahdenmaki, Michael Leach - Hoboken, N.J. John Wiley & Sons c2005 - xvii, 310 σ. ill
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
0471719994 9780471719991 0471721379 9780471721376
Σχεσιακές βάσεις δεδομένων
005.756 5