Answer Detail: RE: What is the diff b/w BTREE INDEX and BITMAP INDEX

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Print |

Question: What is the diff b/w BTREE INDEX and BITMAP INDEX

September 09, 2007 04:04:00	#4
Mohammed Abdul Afroze	Member Since: Visitor Total Comments: N/A
RE: What is the diff b/w BTREE INDEX and BITMAP INDEX
Difference Between B-Tree Index & Bitmap Index. 1. B-tree Index has low cardinality values, where as Bitmap Index has High Cardinality values. 2. B-tree Index is userful for OLTP, where as Bitmap Index is useful for Dataware Housing. 3. B-tree index updates on key values has relatively inexpensive, where as Bitmap index has more expensive.