Interested to Buy Any Domain ? << Click Here >> for more details...
What is a bitmap index?
- 4 Answers
- 23782 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
What is the trigger in sql?
Why select is used in sql?
How can we make an if statement within a select statement?
How do I create a sql script?
What does data normalization mean?
What is delimiter in pl sql?
What is a join?
What are the steps for performance tuning.
What do we need to check in database testing?
What is meant by user defined function?
What is partition in sql query?
What is the difference between rename and alias?
What is difference between sql and excel?
How many rows can sqlite handle?
what is primary key? : Sql dba
