What is a bitmap index?
Answer Posted / satendra
Bit map Indexes are used with the columns having low
cardianality like Gender(M/F),Marital Status.The benefit of
it is that it requires a small space comapred to the case
if a B-Tree index is created on the same column of the
table.
Bit map Indexes are useful in the systems where data is not
getting updated frequently.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is example of database?
What is data manipulation language?
Can we change the table name in sql?
What is database white box testing and black box testing?
How do we accept inputs from user during runtime?
What is primary and foreign key?
how to rename an existing table in mysql? : Sql dba
Explain clause in sql?
Why is partition used in sql?
Can a foreign key be null?
Is sql between inclusive?
What is primary key secondary key alternate key candidate key?
What are hotfixes and patches?
Can we use joins in subquery?
How can I change database name in sql?