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

October 10, 2007 11:02:10	#5
C.RAMESH	Member Since: Visitor Total Comments: N/A
RE: What is the diff b/w BTREE INDEX and BITMAP INDEX
Btree Index is very usefull for OLTP and BITMAP index are useful for Decision Support System. When OLTP environment higly level DML activites where doing and it is better to use Btree indexes is better than Bitmap indexes. Where as BITMAP indexes is better for Decision support System because there will be few distinct values.