Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


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