Interested to Buy Any Domain ? << Click Here >> for more details...
structural difference between bitmap and btree index ?
- 1 Answers
- 12138 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 |
What happens to the current transaction if the session is ended?
What is a proxy object?
How to see the table columns used in an index?
What is merge statement used for?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain constraining triggers.
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
Where are the settings stored for each instance in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what is the syntax of SELECT command?
What are a collation and state the different types of collation sensitivity?
How to use null as conditions in oracle?
Oracle General 
