What is a bitmap index?
- 4 Answers
- 22907 Views
- Choice Solutions, Infosys, I also Faced
- E-Mail Answers
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
Define concurrency control. : Transact sql
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do I view tables in sql developer?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do I turn a list into a table?
What is the difference between a primary key and a unique key?
What is partition by in sql?
How do I truncate a word?
What are the ways on commenting in a pl/sql code?
how many tables will create when we create table, what are they? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How do I run sql?
What company owns postgresql?
How to run pl sql program in mysql?
What is prepared statement in sql?
