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

December 12, 2008 13:09:34	#7
subajay	Member Since: November 2007 Total Comments: 1
RE: What is the diff b/w BTREE INDEX and BITMAP INDEX
Bitmap index: ------------ A type of index that uses a string of bits to quickly locate rows in a table. Bitmap indexes are normally used to index low cardinality columns in a warehouse environment. Btree index: ------------ A type of index that uses a balanced tree structure for efficient record retrieval. B-tree indexes store key data in ascending or descending order.