• What is the diff b/w BTREE INDEX and BITMAP INDEX

    Answered

    What is the diff b/w BTREE INDEX and BITMAP INDEX?

    Bronze Member Asked on May 18, 2016 in MYSQL.
    Add Comment
  • 3 Answer(s)
    Best answer

    Difference Between B-Tree Index & Bitmap Index.

    1. B-tree Index has low cardinality values, where as Bitmap Index has High Cardinality values.
    2. B-tree Index is userful for OLTP, where as Bitmap Index is useful for Dataware Housing.
    3. B-tree index updates on key values has relatively inexpensive, where as Bitmap index has more expensive.

    Bronze Member Answered on May 18, 2016.
    Add Comment

    Btree Index is very usefull for OLTP and BITMAP index are useful for Decision Support System. When OLTP environment higly level DML activites where doing and it is better to use Btree indexes is better than Bitmap indexes. Where as BITMAP indexes is better for Decision support System because there will be few distinct values.

    Bronze Member Answered on May 18, 2016.
    Add Comment

    Difference Between B-Tree Index & Bitmap Index.

    1. B-tree Index has low cardinality values, where as Bitmap Index has High Cardinality values.
    2. B-tree Index is userful for OLTP, where as Bitmap Index is useful for Dataware Housing.
    3. B-tree index updates on key values has relatively inexpensive, where as Bitmap index has more expensive.

    Bronze Member Answered on May 18, 2016.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.