structural difference between bitmap and btree index ?
Answer / sandeep desai
B-Tree:-Is made of Branch nodes and Leaf nodes
where
Branch nodes hold the prefix key value and also the link to
Leaf node
whereas,
Leafe node is contains Indexed value and ROWID.
Bitmap:-It consists of the bits for every distinct value
Is This Answer Correct ? | 10 Yes | 3 No |
How to define an oracle sub procedure?
How to divide query output into groups in oracle?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
How to update a table row with a record?
How to define an anonymous block?
List the types of joins used in writing subqueries?
who is the father of oracle and send chodd rules
What is difference between Rename and Alias?
What is a system tablespace?
How to delete multiple rows from a table in oracle?
Is oracle an open source?
What is the difference between count (*), count (expression), count (distinct expression)?