Chapter 13. DBMS-Specific Indexing Options

  1. Tapio Lahdenmäki,
  2. Michael Leach

Published Online: 27 JAN 2005

DOI: 10.1002/0471721379.ch13

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) DBMS-Specific Indexing Options, 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.ch13

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 (85K)

Keywords:

  • DBMS options;
  • index row suppression;
  • index keys;
  • additional index columns;
  • constraints;
  • uniqueness enforcement;
  • bi-directional indexes;
  • index key truncation;
  • function-based indexes;
  • index skip scan;
  • block indexes;
  • data-partitioned secondary indexes;
  • Oracle

Summary

DBMS Options: Index row suppression and exceptional conditions; additional index columns after the index key; constraints to enforce uniqueness; reading indexes in both directions; index key truncation; function-based indexes; index skip scan; block indexes; data-partitioned secondary indexes.

Get PDF (85K)