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

Jim C. Nasby jnasby at pervasive.com
Tue Dec 13 07:46:13 GMT 2005


Any plans to extend this so that you don't have to specify an attribute
list?

On Tue, Dec 13, 2005 at 02:25:26AM -0500, Jie Zhang wrote:
> 
> 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.
> 
> _______________________________________________
> Bizgres-general mailing list
> Bizgres-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/bizgres-general
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


More information about the Bizgres-general mailing list