MySQL支持位图索引吗？

Question

MySQL支持位图索引吗？语法是什么？

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

简短的回答--不，它没有。截至今天(MySQL 8.0)，它只包含两种类型的索引-哈希和BTREE。