Pradeep
What is the difference between B TREE INDEX and BITMAP INDEX?
By Pradeep in Databases & DBA on Sep 01 2009
  • Partap Tanwar
    Sep, 2009 1

    Bitmap indexes are more advantageous than b-tree indexes when the table has millions of rows and the key columns have low cardinality. Bitmap indexes provide better performance than b-tree indexes when queries often use a combination of multiple where conditions involving or operator, the table is read-only, or when there is low update activity on the key columns.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS