[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