Interested to Buy Any Domain ? << Click Here >> for more details...
What is a bitmap index?
- 4 Answers
- 23977 Views
- Choice Solutions, Infosys, I also Faced
- E-Mail Answers
Answer Posted / rahul roshan
Bitmap indexes have traditionally been considered to work well for data such as Boolean values, which have a modest number of distinct values – in this case, boolean True and False - but many occurrences of those values. This would happen if, for example, you had data on whether or not each resident in a city has internet access. Bitmap indexes use bit arrays (commonly called bitmaps) and answer queries by performing bitwise logical operations on these bitmaps. Bitmap indexes have a significant space and performance advantage over other structures for query of such data. Their drawback is they are less efficient than the traditional B-tree indexes for columns whose data is frequently updated: consequently, they are more often employed in read-only systems that are specialized for fast query - e.g., data warehouses, and generally unsuitable for online transaction processing applications. However, this drawback appears to apply only to their implementation in relational database management systems: certain non-relational DBMSs, notably Intersystems Cache, a hierarchical database, use bitmap indexes for low-cardinality columns in transactional systems.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it important to partition hard disk?
Is left join faster than inner join?
how to use case expression? : Sql dba
What are user defined functions?
Why are indexes and views important to an organization?
What is difference between pls_integer and integer?
What is mutating error?
Explain the insert into statements in sql?
What are literals in sql server?
what is the difference difference between procedure and packages
What are sql functions? Describe in brief different types of sql functions?
What are the types of join and explain each?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
describe transaction-safe table types in mysql : sql dba
How many sql are there?
