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
Πανεπιστήμιο Πατρών, Βιβλιοθήκη & Κέντρο Πληροφόρησης, 265 04, Πάτρα
Τηλ: 2610969621, Φόρμα επικοινωνίας
Εικονίδιο Facebook Εικονίδιο Twitter Εικονίδιο Soundcloud