Bitmap Index

• bitmap index: a fast data structure that speeds up queries

Creating and dropping index is essentially a schema change job. For details, please refer to Schema Change.

Display the lower index of the specified table_name

• Currently only index of bitmap type is supported.
• The bitmap index is only created on a single column.
• Bitmap indexes can be applied to all columns of the , Uniq data model and key columns of the Aggregate models.
• The data types supported by bitmap indexes are as follows:
  • TINYINT
  • BIGINT
  • CHAR
  • DATE
  • DATETIME
  • LARGEINT
• The bitmap index takes effect only in segmentV2. The table’s storage format will be converted to V2 automatically when creating index.

For more detailed syntax and best practices for using bitmap indexes, please refer to the / SHOW INDEX / command manual. You can also enter HELP CREATE INDEX / HELP SHOW INDEX / HELP DROP INDEX on the MySql client command line.