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 sqlca in db2?
What is varchar sql?
How can use stored procedures in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
How can I get the number of records affected by a stored procedure?
What are the different types of database management systems?
how to escape special characters in sql statements? : Sql dba
Can we alter stored procedure?
What is faster join or subquery?
Define join and name different types of joins?
What are all the different normalizations?
how to create a test table in your mysql server? : Sql dba
What is union, minus and interact commands?
What is the largest value that can be stored in a byte data field?
Can a select statement fire a trigger?