Interested to Buy Any Domain ? << Click Here >> for more details...
structural difference between bitmap and btree index ?
- 1 Answers
- 12046 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 the difference between count (*), count (expression), count (distinct expression)?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to invoke the original export import utilities?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to create a table interactively?
Explain how you would restore a database using RMAN to Point in Time?
What is a user role in oracle?
Explain an integrity constrains?
What are the differences between number and binary_float in oracle?
what happened to the global index when I truncate the data in one of the partition?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to bring a tablespace online?
What is flashback in Oracle?
What is meant by joins? List out the types of joins.
Explain the use of full option in exp command.
