Chapter 10. Multiple Index Access

  1. Tapio Lahdenmäki,
  2. Michael Leach

Published Online: 27 JAN 2005

DOI: 10.1002/0471721379.ch10

Book Title

Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al.

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) Multiple Index Access, 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.ch10

Author Information

  1. Smlednik, Slovenia, Shrewsbury, England

Publication History

  1. Published Online: 27 JAN 2005
  2. Published Print: 24 JUN 2005

ISBN Information

Print ISBN: 9780471719991

Online ISBN: 9780471721376

SEARCH

CHAPTER TOOLS

Get PDF (491K)

Keywords:

  • index ANDing;
  • pitfalls;
  • single index;
  • query tables;
  • fact tables;
  • bitmap indexes;
  • index ORing;
  • boolean predicates;
  • SQL Server index joins

Summary

Index ANDing; their pitfalls and comparison with the use of a single index. Their use with query tables and fact tables. Bitmap indexes. Index ORing; boolean predicates; a comparison with the use of a single index. SQL Server Index Joins.

Get PDF (491K)