Relational database index design and the optimizers: DB2, Oracle, SQL Server
Tipo de material:
TextoDetalles de publicación: New Jersey: John Wiley & Sons, 2005Descripción: xvii, 310p.: ilISBN: 0471719994Tema(s): SQL (Lenguaje de programación para computadores) | BASES DE DATOS RELACIONALESClasificación CDD: 005.75
Contenidos:
1 Introduction - 2 Table and index organization - 3 SLQ Processing - 4 Deriving the ideal index for a select - 5 Proactive index design - 6 Factors affecting the index design process - 7 Reactive index design - 8 Indexing for table joins - 9 Star join considerations - 10 Multiple index access - 11 Indexes and reorganization - 12 DBMS-Specific indexing restrictions - 13 DBMS_Specific indexing options - 14 Optimizer are not perfect -15 Aditional estimation considerations - 16 Organizing the index design process.
| Tipo de ítem | Biblioteca actual | Colección | número de clasificación | Copia número | Estado | Notas | Fecha de vencimiento | Código de barras |
|---|---|---|---|---|---|---|---|---|
Libro General
|
Biblioteca Campus San Joaquín | Colección General | 005.75 L183 (Navegar estantería(Abre debajo)) | 1 | Disponible | 3560902014989 |
1 Introduction - 2 Table and index organization - 3 SLQ Processing - 4 Deriving the ideal index for a select - 5 Proactive index design - 6 Factors affecting the index design process - 7 Reactive index design - 8 Indexing for table joins - 9 Star join considerations - 10 Multiple index access - 11 Indexes and reorganization - 12 DBMS-Specific indexing restrictions - 13 DBMS_Specific indexing options - 14 Optimizer are not perfect -15 Aditional estimation considerations - 16 Organizing the index design process.
9