SHOW EXPLAIN feature was introduced in MariaDB 10.0. It enables us to get an
EXPLAIN (that is, a description of the query plan) of the query running in a given thread.
ISFDB database as described in the Importing the data exported by mysqldump recipe of this chapter.
mysqlcommand-line client and connect to the
ALTER TABLE title_relationships DROP KEY titles;
SELECT titles.title_id AS ID, titles.title_title ...