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.
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. To drop an index, select the index and click the (minus) button.
Use the Index Name and Index
Kind dialogs 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 option from the drop-down menu that appears.
This is a translation of the MySQL Administrator Manual that can be found at dev.mysql.com. The original MySQL Administrator Manual is in English, and this translation is not necessarily as up to date as the English version. Даний документ є перекладом оригінальної англійської документації по MySQL Administrator яка доступна за адресою dev.mysql.com .
