Type
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
-
collatedkey — an index on the given property, using the collation of that property
-
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
-
“Index Definitions” in this book
-
“Defining and Building Indices” in the Caché SQL Optimization Guide
-
“Introduction to Compiler Keywords” in Using Caché Objects