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

However, the difference in time can be minimal if we only have limited test data
compared to a real table in production.
Detection of Index Problems
Since version 2.6.1, phpMyAdmin tries to detect some common index problems. For
example, let's access the topics table and add an index on the author_id column.
When we display this table's structure, we get a warning:
The intention here is to warn us about an inefficient index structure when
considering the whole table. We don't need to have two indexes that start with the
same column.
We should consider this feature as work in progress, and even the warnings emitted
by version 2.8.2 are not perfect in this matter.
Summary
In this chapter we saw how to add fields, including special field types like TEXT,
BLOB, ENUM, and SET, how to use a calendar popup for DATE, DATETIME,
and TIMESTAMP fields, and how to upload binary data into a BLOB field. We
also learned how to manage indexes (multi-field and full-text) and get feedback
from MySQL about which indexes are used in a specific query .