Chapter 5. Proactive Index Design
Published Online: 27 JAN 2005
DOI: 10.1002/0471721379.ch5
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) Proactive Index Design, 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.ch5
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;
- index design techniques;
- basic question;
- BQ;
- Quick Upper Bound Estimate;
- QUBE;
- touches;
- SQL application design;
- index improvements;
- SQL performance;
- index design;
- three star index;
- ideal index;
- fat index;
- semi-fat index;
- index design algorithm;
- best index design
Summary
An introduction to the two fast and easy to use techniques that will be used extensively throughout this book: The Basic Question, BQ, and the Quick Upper Bound Estimate, QUBE. The application of the principles discussed in Chapter 4 to the SQL application design process. The use of these techniques to determine the merits and demerits of potential index designs and to determine improvements necessary to provide adequate SQL performance. An assessment of the suitability of any improvements considered. When the QUBE should be used.