Chapter 12. DBMS-Specific Indexing Restrictions

  1. Tapio Lahdenmäki,
  2. Michael Leach

Published Online: 27 JAN 2005

DOI: 10.1002/0471721379.ch12

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 Restrictions, 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.ch12

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

Keywords:

  • index restrictions;
  • maximum index columns;
  • maximum index lengths;
  • variable length columns;
  • maximum indexes per table;
  • maximum index size;
  • index locking;
  • index row suppression;
  • null values;
  • SQL Server;
  • Oracle;
  • DB2 for z/OS

Summary

The restrictions applied to indexes by relational database management systems: the maximum number and length of the index columns; variable length columns; the maximum number of indexes per table; the maximum size of an index; index locking; index row suppression with null values.

Get PDF (63K)