Chapter 15. Additional Estimation Considerations
Published Online: 27 JAN 2005
DOI: 10.1002/0471721379.ch15
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) Additional Estimation Considerations, 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.ch15
Publication History
- Published Online: 27 JAN 2005
- Published Print: 24 JUN 2005
ISBN Information
Print ISBN: 9780471719991
Online ISBN: 9780471721376
- Summary
- Chapter
Keywords:
- QUBE;
- QUBE assumptions;
- non-leaf pages;
- leaf pages;
- table pages;
- buffer pools;
- subpools;
- disk read cache;
- pessimistic QUBE;
- memory;
- small tables;
- hotspots;
- comebacks;
- skip-sequential;
- CQUBE, CPU Quick Upper Bound Estimate;
- CPU calculations;
- default CPU coefficients;
- CPU measurements;
- CPU considerations;
- CPU estimates;
- index design comparisons;
- DB2 for z/OS
Summary
A more detailed look at the assumptions behind the QUBE: non-leaf pages and leaf pages with regard to buffer pools, subpools and disk read cache. Occasions when the response time can be much less than the QUBE: leaf and table pages remaining in memory; small tables, hotspots and comebacks; skip-sequential. Calculating the CPU time: default CPU coefficients; measurements and considerations; CPU estimates used in making index design comparisons.