Interested to Buy Any Domain ? << Click Here >> for more details...
structural difference between bitmap and btree index ?
- 1 Answers
- 12142 Views
- Infosys, I also Faced
- E-Mail Answers
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
What is archive log in Oracle?
How to use an explicit cursor without open statements?
How to select an oracle system id (sid)?
What is the disadvantage of User defind function?
How to create a new table in oracle?
What is a snapshot log?
What is difference between truncate and delete?
What happens if you lost a data file?
What do database buffers contain?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Difference between hot backup vs. Cold backup?
How to view the tablespaces in the current database?
How to create a new view in oracle?
Explain oracle insert into command?
What is a trigger and what are its types in oracle?
