Answered Questions

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

    Prabhat Sahu

    • Oct 21st, 2017

    B-Tree Index:
    1. Oracle Default index.
    2. Cardinality is High, means less duplicate(more unique records) (i.e. Rowid)

    Bitmap Index:
    1. Cardinality is Low, means more duplicate.(most of the values are repetative)
    2. Flag related columns ( i.e. M/F, Y/N, 1/0 )

    Vineet

    • Oct 12th, 2017

    1. B-tree Index has high cardinality values, where as Bitmap Index has low Cardinality values.