Changing Table Structures - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 95

We want a FULLTEXT index on the description field so that we are able to locate
a book from words present in its description. After the index has been created, it
looks like:

Depending on the MySQL version, we might see 1 as the field length for the newly
created index. In fact, MySQL does not support the idea of an index length for
FULLTEXT indexes: the index is always on the whole field, but this 1 would be the
value reported by MySQL.

Table Optimization: Explaining a Query : Explaining a Query

In this section, we want to get some information about the index that MySQL uses
for a specific query, and the performance impact of not having defined an index.

Optimization: Explaining a Query

Let's assume we want to use the following query:

SELECT *
FROM `topics`
WHERE author_id = 2 AND language = 'es'

We want to know which topic written by author 2 are in the es language, our code
for Spanish.

To enter this query, we use the SQL link from the database or the table menu, or the
SQL query window. We enter this query in the query box and click Go . Whether the
query finds any results is not important right now.