phpMyAdmin has a number of index management options, which we will cover in this section.
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:
Here is how to fill in this panel:
Index name...