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 |
What is forall Statement ?
What is a oracle database?
what is the scenario where you take the database to NoArchivelog mode?
Is java required for oracle client?
how to join query for one source type is oracle another source type is sql server ?
What is a Tablespace?
What is not equal to in oracle?
What happens to the current transaction if a ddl statement is executed?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Difference between cartesian join and cross join?
Can group functions be mixed with non-group selection fields?
What is blob data type in oracle?