Previous section   Next 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

Previous section   Next section