TY - BOOK AU - Lahdenm�aki,Tapio AU - Leach,Mike TI - Relational database index design and the optimizers: DB2, Oracle, SQL server et al. SN - 0471719994 AV - QA76.9.D3 L335 2005eb U1 - 005.75/65 22 PY - 2005/// CY - Hoboken, N.J. PB - John Wiley & Sons KW - Relational databases KW - Bases de donn�ees relationnelles KW - COMPUTERS KW - Programming Languages KW - SQL KW - bisacsh KW - fast KW - Relationele databanken KW - gtt KW - Indexeren KW - Computer Science N1 - 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; Electronic reproduction; [Place of publication not identified]; HathiTrust Digital Library; 2010 N2 - Improve the performance of relational databases with indexes designed for today's hardwareOver the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention UR - https://onlinelibrary.wiley.com/doi/book/10.1002/0471721379 ER -