What is a bitmap index?
Answer Posted / a.jyothsna
In a bitmap index, a bitmap for each key value is used
instead of a list of rowids.
Each bit in the bitmap corresponds to a possible rowid. If
the bit is set, then it means that the row with the
corresponding rowid contains the key value. A mapping
function converts the bit position to an actual rowid, so
the bitmap index provides the same functionality as a
regular index even though it uses a different
representation internally. If the number of different key
values is small, then bitmap indexes are very space
efficient. Bitmap indexing is of great benefit to data
warehousing applications.
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How do I run pl sql in sql developer?
What is before and after trigger?
what is a trigger in mysql? : Sql dba
How do I view stored procedures?
How do you concatenate in sql?
Explain how exception handling is done in advance pl/sql?
What is on delete set null?
What happens when a trigger is associated to a view?
what is a composite key ? : Sql dba
What are two statement types in sql?
What is data type in sql?
What is memory optimized?
What is the difference between inner join and outer join?
Explain the steps needed to create the scheduled job?
What is trigger in sql? Explain