When creating an execution plan for a query, the MariaDB optimizer makes a cost-based decision about whether or not to use one or more indexes instead of reading through a table row-by-row. Indexes are often, but not always the faster choice. The extended key's optimization improves the index lookups for InnoDB and XtraDB tables.
Launch the
mysqlcommand-line client application and connect it to our MariaDB server as the root user or as a user with theSUPERprivilege.Enable the extended keys optimization with the following command:
SET GLOBAL optimizer_switch='extended_keys=on';Add the following code to our
my.cnformy.inifile (or to an existing[mysqld]section):[mysqld]
optimizer_switch = 'extended_keys=on'verifies thatextended_keysis set toonwith the following command:SHOW VARIABLES LIKE 'optimizer_switch'\G