bitmap indexes

From: <slniemann_at_my-dejanews.com>
Date: Mon, 16 Nov 1998 16:20:49 GMT
Message-ID: <72pjd1$km5$1@nnrp1.dejanews.com>

I am trying to get some general information about bitmap indexes fitting to my situation.

I have a database containing tables with rows of 750,000+

In these tables is a foreign key of codes (72 distinct) which is set to its description table. These tables do receive a lot of update and insertion, many, many per day.

As I understand it, the bitmap index works best with a static table, but would it be completely idiotic to form bitmap indexes for this column in these tables?

I am still learning about bitmap indexes and could use any feedback you have. Thanks.

S Niemann

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 10:20:49 CST