Chapter 6. Factors Affecting the Index Design Process
Published Online: 27 JAN 2005
DOI: 10.1002/0471721379.ch6
Copyright © 2005 John Wiley & Sons, Inc.
Book Title
Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al.
Additional Information
How to Cite
Lahdenmäki, T. and Leach, M. (2005) Factors Affecting the Index Design Process, in Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al., John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/0471721379.ch6
Publication History
- Published Online: 27 JAN 2005
- Published Print: 24 JUN 2005
ISBN Information
Print ISBN: 9780471719991
Online ISBN: 9780471721376
- Summary
- Chapter
Keywords:
- index design;
- I/O time;
- I/O estimates;
- optimizers;
- multiple thin slices;
- DBMS specifics;
- difficult predicates;
- boolean term predicates;
- filter factor problems;
- pitfalls;
- Oracle;
- DB2 for z/OS
Summary
Important factors that affect the index design process considered in Chapters 4 and 5; verification of the I/O time estimates; multiple thin slices; DBMS specifics; difficult predicates for optimizers; boolean term predicates; filter factor problems and pitfalls.