Does MySQL support for BITMAP indexes?

Question

Does MySQL support BITMAP indexes? What's the syntax?

mysql> CREATE BITMAP INDEX ON tb1(num);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'BITMA
P INDEX ON tb1(num)' at line 1

Answer 1

Short answer - no, it doesn't. As of the today (MySQL 8.0), it contains only two types of indexes - HASH and BTREE.