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, 2006 02:30:55	#3
Adarsh S Pazhayampillil	Member Since: Visitor Total Comments: N/A
RE: What is the diff b/w BTREE INDEX and BITMAP INDEX
b-tree indexes are used usuall when we have too many distinct columns and for high cardinaties . and bitmap indexex are used for low cardinaties, usually when we have repeated columns.