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?

Type

Specifies the type of index.

Usage

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

Details

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.

Default

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

See Also

Feedback