Indices tab holds all index information
for your table. You can add, drop, and modify indexes using
the indices tab, in combination with the column editor.
To add an index, click the + (plus)
button below the index list. The MySQL Query Browser prompts for
an index name and the new index is created. Under Windows, you
can change the automatically generated index name by using the
Options dialog window. For more
information, see Section 21.5, “Editors”.
To drop an index, select the index and click the – (minus) button.
Use the Index Name and Index
Kind dialog boxes to modify the name and type
so on) of the index.
To add columns to an index, either click and drag the column to the Index Columns box or select the column you wish to add and click the + (plus) button to the right of the Index Columns box. You can remove a column from the index by selecting the column and clicking the – (minus) button to drop the column from the index.
To change an index to only refer to a column prefix (such as with the CHAR and VARCHAR string data types), select the index column you wish to prefix in the Index Columns box and then click the arrow icon to the right of the Index Columns box. Select the Set Index Column Length option from the drop-down menu that appears.