Re: Looking for effective Bitmap Index Strategy

James,

I used to follow the cardinality rules pretty much as Oracle suggests, but at Oracle OpenWorld98, a paper was presented which said use bitmaps on any none unique column.

http://www.oracle.com/oow/owa/search.presesp

and search for bitmap index in the abstract section.

Kinda makes it harder to apply an effective strategy as the bitmap index technology keeps getting better and better.

Chris.

James wrote:
>
> I have some questions on how to establish an effective strategy to use bitmap
> indexes with 7.3.4.3.
>
> We have recently applied the 7.3.4.3 patchset, upgrading from 7.3.4.0. I would
> like to use the bitmap indexes where ever possible. This database supports a
> PeopleSoft installation and I need to get better performance for the business.
>
> When we started running with the patchset, we received an ORA-600 (I opened a
> TAR) that was fixed by setting the v733_plans_enabled to FALSE. Then last
> night we started getting ORA-600[20003]. According to Oracle, the work
> around for this is to "not used" bitmap indexes. I had added one more to the
> table yesterday. This table then had four bitmap indexes on it. We had
> three bitmap indexes on this for over 10 days.
>
> There are a lot of things to like about bitmap indexes, fast query
> performance, small size. But these ORA-600 are starting to be a REAL
> nuisance.
>
> Has anyone out there developed a strategy for 7.3.4 and bitmap indexes. The
> environment is 7.3.4.3 running on IBM RS/6000 AIX 4.3.1,
>
> Thanks
> James
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Mar 13 1999 - 17:14:03 CST