Bug #30347 Support Bitmap Indexes
Submitted: 9 Aug 2007 23:12 Modified: 9 Aug 2007 23:16
Reporter: Andrew A Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[9 Aug 2007 23:12] Andrew A
Please consider adding support for an additional index type, bitmap indexes.

Oracle has a decent explanation on this index type at http://www.oracle.com/technology/pub/articles/sharma_indexes.html

Bitmap indexes would be very useful in a data warehouse environment when many rows will contain the same amount of data (for aggregation), unlike b-tree indexes which are good for unique column values.

How to repeat:
[9 Aug 2007 23:16] Miguel Solorzano
Thank you for the bug report feature request.
[30 Nov 2009 0:05] Zacheusz Siedlecki
there is existing feature request: http://forge.mysql.com/worklog/task.php?id=1524