A bitmap index is a special type of index that is primarily used in the Oracle database.
Bitmap indexes are meant to be used on low cardinality columns. A low cardinality column just means that the column has relatively few unique values.
every bit corresponds to a row in the table. A binary value of ’1′ means that the particular index record has it’s the corresponding row set to the value that index record represents.
CREATE BITMAP INDEX IX_PEOPLE_SEXUAL_ORIENTATION
ON PEOPLE (SEXUALORIENTATION);
Read full article from What is a bitmap index?
Bitmap indexes are meant to be used on low cardinality columns. A low cardinality column just means that the column has relatively few unique values.
every bit corresponds to a row in the table. A binary value of ’1′ means that the particular index record has it’s the corresponding row set to the value that index record represents.
CREATE BITMAP INDEX IX_PEOPLE_SEXUAL_ORIENTATION
ON PEOPLE (SEXUALORIENTATION);
Read full article from What is a bitmap index?
No comments:
Post a Comment