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
Why cursor variables are easier to use than cursors?
How to store only time; not date and time?
IS it possible to built the oracle database without setting the kernal parameters?
How to use "while" statements in oracle?
What are the different types of partitions in oracle?
Explain what are the characteristics of data files?
What are the database administrators utilities available?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How do we represent comments in oracle?
What is meant by joins?
How to install oracle odbc drivers?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to run create database statement again?
Explain the difference between sap and oracle?
How to use an explicit cursor without open statements?