Difference between bitmap and btree index in oracle

Structural difference between bitmap and btree index in oracle.

Structural difference between bitmap and btree index

Btree
It is made of branch nodes and leaf nodes. Branch nodes holds prefix key value along with the link to the leaf node. The leaf node in turn contains the indexed value and rowed.

Bitmap
It simply consists of bits for every single distinct value. It uses a string of bits to quickly locate rows in a table. Used to index low cardinality columns.
Convert oracle table data into excel sheet - oracle
Convert oracle table data into excel sheet - There are 2 ways to do so: 1. Simply use the migration wizard shipped with Oracle...
When should we go for hash partitioning? - oracle
Hash partitioning - Scenarios for choosing hash partitioning: Not enough knowledge about how much data maps into a give range...
What is Materialized view? What is a snapshot? - oracle
Materialized view and snapshot - A materialized view is a database object that contains the results of a query. A snapshot is similar to materialized view...
Post your comment