Question: what is the difference between b-tree and bitmap index?
Answer: The basic differences between b-tree and bitmap indexes include: 1: Syntax differences: The bitmap index includes the "bitmap" keyword. ... 2: Cardinality differences: The bitmap index is generally for columns with lots of duplicate values (low cardinality), while b-tree indexes are best for high cardinality columns.