The 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.

Figure 10.3. The Index 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 11.4, “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 (UNIQUE, FULLTEXT, and 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.