Chapter 1. Introduction
Published Online: 27 JAN 2005
DOI: 10.1002/0471721379.ch1
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) Introduction, 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.ch1
Publication History
- Published Online: 27 JAN 2005
- Published Print: 24 JUN 2005
ISBN Information
Print ISBN: 9780471719991
Online ISBN: 9780471721376
- Summary
- Chapter
Keywords:
- objectives;
- SQL optimizers;
- table and index scans;
- quantify the work being done during these scans;
- index design;
- audience;
- background;
- inadequate indexing;
- systematic index design
Summary
The objectives of this book; firstly, to understand how SQL optimizers decide what table and index scans should be performed to process SQL statements as efficiently as possible; secondly, to be able to quantify the work being done during these scans to enable satisfactory index design. For what type of audience and background the book is written. Initial thoughts on the major reasons for inadequate indexing. Systematic index design.