structural difference between bitmap and btree index ?
- 1 Answers
- 11649 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
When do we use group by clause in a sql query?
Difference between open_form and call_form in oracle.
What is an UTL_FILE.What are different procedures and functions associated with it?
How do we know whether an index is created on a table ???
How are Indexes Update ?
What is max rowid in oracle?
Explain an exception?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
What is a table index?
Calculate difference between 2 date / times in oracle sql?
how to produce numbers from 1 to 10 using dual table
Can we create more than one index on particular column?
Oracle General 
