On Thu, 19 Jun 2003 cure(at)icpnet(dot)pl wrote:
> Hello All
>
> is in postgres any possibility to create bitmap index ? I have big
> (~12 000 000 records) table where one field have limited count of
> values. Many queries use this field in where section. I thing that
> bitmap index will by better than BTree.
> How i can optimize select on this table ?
Might a partial index help?
create index tb_dx on tb (field) where field=1
kind of thing?