Indexes for MariaDB Xpand

Overview

MariaDB Xpand provides DDL (Data Definition Language) syntax to create, alter, or drop indexes:

  • Xpand performs many DDL operations as online schema changes, which allows concurrent reads and writes during the operation

  • Xpand's DDL syntax is very similar to the DDL syntax of MariaDB Enterprise Server and MySQL 5.7

In the context of ISO 9075-2:2016, this page uses "DDL (Data Definition Language)" to refer to SQL statements in the standard's "SQL-schema statements" group.

Compatibility

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1