structural difference between bitmap and btree index ?
Answer Posted / 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 |
Post New Answer View All Answers
How to unlock the sample user account in oracle?
Use of an integrity constraint is better to validate data. Explain
How to use regular expression in pattern match conditions in oracle?
What are the common oracle dba tasks?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to pass a parameter to a cursor in oracle?
How to delete a column in an existing table?
What is the difference between alert log file and tarce file ?
What is the difference between 10g OEM and 11g OEM?
How to sort the query output in oracle?
How to open a cursor variable?
What is oracle update statement with inner join ?
In the oracle version 9.3.0.5.0, what does each number shows?
How to create an initialization parameter file?
Difference between cartesian join and cross join?