Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


Specifies the type of index.


To specify the type of the index, use the following syntax:

Index name On property_expression_list [ Type = indextype ];

Where indextype is one of the following:

  • bitmap — a bitmap index

  • bitslice — a bitslice index

  • index — a standard index (default)

  • key — deprecated


This keyword specifies the type of the index, specifically whether the index is implemented as a bitmap index or a standard (regular, non-bitmap) index.

A bitmap index cannot be marked as unique.


If you omit this keyword, the index is a standard index.

See Also