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
What is the use of & in pl sql?
What is basic structure of pl sql?
What is sql dialect?
what is index? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
What is the primary use of normalization?
Can we connect to postgresql using sql developer?
What is a temporal table?
what is timestamp in mysql? : Sql dba
What are different types of sql?
What type of join is sql join?
What is offset in sql query?
Is hadoop a nosql?
Can we use two order by clause in query?
How to execute a stored procedure?