Interested to Buy Any Domain ? << Click Here >> for more details...
structural difference between bitmap and btree index ?
- 1 Answers
- 12128 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 |
Is java required for oracle client?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
Why do you create or replace procedures rather that drop and recreate.
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Write a trigger example in oracle?
What is the Tune Query
What privilege is needed for a user to create indexes in oracle?
What is a snapshot log?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is a trace file and how is it created in oracle?
What is the diff between Oracle and SQL Server
What is a materialised view?
Oracle General 
