[Bizgres-general] Latest bitmap performance results..

[Jie Zhang]

Ayush,

> QUERY PERFORMANCE (time in seconds for query to finish):
> (in case of bitmap all columns have bitmap index while in case of btree all
> columns have btree index)
> ----------------------------------------------------------
>            Bitmap  Btree
> ----------------------------------------------------------
> Query 1    136.3   393.5
> Query 2    60.7    391.6
> Query 3    97.3    186.7
> Query 4    102.5   282.9
>Query 5    61.6    358.9
> ----------------------------------------------------------

Do you see any query performance results showing that the bitmap index with
the latest patch performs better than the previous one? I think
some of them will be better, since bitmap pages for a bitmap vector are
more likely to be allocated together in the latest patch.

Thanks,
Jie