Interested to Buy Any Domain ? << Click Here >> for more details...
What is a bitmap index?
- 4 Answers
- 23969 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 are some predefined exceptions in pl/sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
How do you go back in sql?
How do I upgrade sql?
Why do we use procedures in pl sql?
How can you load multi line records? : aql loader
What are the dml statements?
How do you write a complex sql query?
What is the difference between view and stored procedure?
What can you do with pl sql?
How exception handling is done in advance pl/sql?
What are its different types of dbms?
How to display Row Number with Records in Oracle SQL Plus?
Can we connect to postgresql using sql developer?
What is dml statement?
