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

Index Management
phpMyAdmin has a number of index management options, which we will cover in
this section.
Single-Field Indexes
We have already seen how the Structure panel offers a quick way to create an index
on a single field, thanks to some quick links like Primary , Index , and Unique . Under
the field list, there is a section of the interface used to manage indexes:
This section has links to edit or delete every index. Here, the Field part lists only one
field per index, and we can see that the whole field participates in the index because
there is no size information after each field name - contrary to what will be seen in
our next example.
We will now add an index on the title. However, we want to restrict the length of
this index to reduce the space used by the on-disk index structure. The Create an
index on 1 columns option is appropriate, so we click Go . In the next screen, we
specify the index details as shown in the following screen: