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, 2006 04:44:22	#2
manish.hoiyani	Member Since: Visitor Total Comments: N/A
RE: What is the diff b/w BTREE INDEX and BITMAP INDEX
b-tree indexes are used for high cardinaties, usuall when we have too many distinct columns. and bitmap indexex are used for low cardinaties, usuallywhen we have repeated columns