| |
GeekInterview.com > Interview Questions > Oracle > General
| Print | |
Question: 1. What is Bitmapped indexes?
2. What is b-tree index?
|
| June 06, 2008 13:44:56 |
#2 |
| sweetytrivedi |
Member Since: June 2008 Total Comments: 7 |
RE: 1. What is Bitmapped indexes?2. What is b-tree index?
|
| B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system. |
| |
Back To Question | |
