B-tree vs Bitmap index
B-tree vs bitmap index ================= In this post i would like talk about index that to mainly b-tree vs bit man index. Both are used to play key role in performance of query. lets some comparison of both:- B-tree :- it is one Default index, Like create index on one or columns using tree like structure. Cardinality is High, means less duplicate don`t confuse some people call it function based index as in. syntax example:- CREATE INDEX <index_name> ON <table_name>( function (column_name)); Bitmap :- Carnality is Low, means more duplicate. bitmap index create name with bimap key word, Bitmap only can use in oracle Enterprise edition, standard edition we can not use this feature. syntax example:- CREATE BITMAP INDEX <index_name> ON <table_name> ( column_name ); still we can add on more points, but i want to hear from your side also. so please post your opinion about index types in comment session.