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.

Download Oracle Architecture and Concepts PDF 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?