Skip to main content


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

  • collatedkey — an index on the given property, using the collation of that property

  • 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

FeedbackOpens in a new tab