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 select some rows from a table in oracle?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
What are set operators?
What is the function of Redo Log ?
How to create a testing table in oracle?
How view is different from a table?
How to convert characters to dates in oracle?
How to start your 10g xe server?
Explain table?
What is clustered table in Oracle?
What is Data Block ?
what is kernel?