Using bitmap indexes

From: <dbaplusplus_at_hotmail.com>
Date: 11 Nov 2006 19:40:34 -0800
Message-ID: <1163302834.610825.43850@b28g2000cwb.googlegroups.com>

I am using Oracle 9.2.0.5 on HP UNIX 11i. There are some large tables
(million rows) in which access is done on columns with low cardinality
(e.g., region). A bitmap index will be a good fit, but whenever I read
Oracle litertaue on bitmap indexes, it says if table is modified (i.e., new rows being added/deleted), do not use bitmap indexes. My application is combination of OLTP and data warehouse, i.e, table is being modified but not that much, i.e, there may be 1000 rows added every day.

Will I see performnace imporvements in using bitmap indexes in such cases?

Thanks. Received on Sat Nov 11 2006 - 21:40:34 CST