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 can you merge two tables in oracle?
Where do we use decode and case statements?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What are the types of synonyms?
How do I start tns listener?
What are the differences between char and varchar2 in oracle?
What is open database communication (odbc) in oracle?
What is the difference between normal and corelated subqueries?
Is oracle a relational database?
what are different types of locks?
what is the difference between authorization and authentication?