Concepts and Architecture Question:

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

Tweet Share WhatsApp

Answer:

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 the OR operator, the table is read-only, or when there is low update activity on the key columns.

Read All 82 Oracle Architecture and Concepts Questions
Previous QuestionNext Question
What is Oracle Identity Analytics?If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?