[Bizgres-general] A bitmap index access method is available in bizgres CVS tip

Jie Zhang jzhang at greenplum.com
Tue Dec 13 07:25:26 GMT 2005


A bitmap index access method is now available in bizgres CVS tip. The
bitmap index is a highly efficient structure to index high dimensional
data, especially when the attributes to be indexed have very low
cardinalities.

To create a bitmap index on desirable attributes, use the following command:

create index <index_name> on <table_name> using bitmap(<att_list>);

Here, <att_list> can be a single attribute or multiple attributes in
table <table_name>. Multiple attributes are separated by a comma.

Note: to use this feature, you need to do initDB.



More information about the Bizgres-general mailing list