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 |
What is catalog in Oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
definition of cluster and non-clustered index?
What privilege is needed for a user to insert rows to tables in another schema?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to change program global area (pga) in oracle?
Explain about integrity constraint?
How to compare dates in oracle sql?
select * from emp what happened internally when we write this query in the sql prompt?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to loop through data rows in the implicit cursor?
How to display the hierarchy of employee and managers without using connect by prior.