Difference Normal INDEX And BITMAP INDEX

Difference Normal INDEX And BITMAP INDEX

Normal index is cannot give indexes for Duplicate values in column values
But BITMAP INDEX is gives Indexes for duplicate values also depend on Their ROWID.
So BITMAP INDEX created on columns containing less distinct values means duplicates contain column for better performance BITMAP INDEX.
WE can use B-Tree index where data cardinality is high and many DML operations are performed and have many distinct values. while Bitmap will use when have low cardinality and less distinct value like gender column(M/F) or value does not update frequently

Comments