Relational database index design and the optimizers [electronic resource] DB2, Oracle, SQL server et al. Tapio Lahdenmaki, Michael Leach
Τύπος υλικού:![Κείμενο](/opac-tmpl/lib/famfamfam/BK.png)
- 0471719994
- 9780471719991
- 0471721379
- 9780471721376
- 005.756 5 22
Ελλιπή περιεχόμενα:
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
Τύπος τεκμηρίου | Τρέχουσα βιβλιοθήκη | Ταξιθετικός αριθμός | Κατάσταση | Ημερομηνία λήξης | Ραβδοκώδικας |
---|---|---|---|---|---|
![]() |
ΒΚΠ - Πατρα | 005.756 5 LAH (Περιήγηση στο ράφι(Άνοιγμα παρακάτω)) | Διαθέσιμο |
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