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 are the different parts of a package?
What are functions in sql?
How do I kill a query in postgresql?
What is difference between cursor and trigger?
How to call shell script from pl sql procedure?
explain the advantages and disadvantages of stored procedure? : Sql dba
How do I run a sql script?
List the various privileges that a user can grant to another user?
How to handle bulk data?
How do I partition in sql?
what does myisamchk do? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
What are tables and fields?
Why do we use cursors?
What is the example of procedure?