Re: Partitioning or BitMap-Index?

On Thu, 13 Feb 2003 03:38:16 +1100, "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:

>Is the column subject to change, ie DML? If so, run away from bitmap
>indexes. A single bitmap index on a table is also not the world's most
>useful thing -their power really comes from the combination of lots of
>them.
>
>If you partition by this column of 1s and 0s, you are (presumably) going
>to end up with two large slabs of data. Not sure if that would buy you
>very much in terms of performance... it depends so much on what other
>things are going on in your SQL. On the other hand, it wouldn't be
>difficult to test.

Yes, your are right it won't be dificult to test. On the other hand I like to get some opions from other users here.

As I wrote in the other reply to the former posting I am currently using this column with possible values of 0 and 1. The data in this column is onyl created when the dataset is created in the table. There are no DML-Statements on this column and the column is used in every SQL-Statement witch run against the table in the where-clause.

What do you think about it?

Regards,

Christian Received on Thu Feb 13 2003 - 00:27:19 CST