Online Documentation for SQL Manager for MySQL
Indices
Indices are objects used to find rows with specific column values quickly. If a table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data.
Table indexes are managed within the Indices tab of Table Editor.
To create a new table index:
- open the table in Table Editor;
- proceed to the Indices tab there;
- right-click the tab area and select the New Index context menu item, or press the Ins key;
- define the index properties using the Index Editor dialog.
To edit an existing table index:
- open the table in Table Editor;
- proceed to the Indices tab there;
- right-click the index and select the Edit Index context menu item, or simply double-click the index;
- edit the index properties using the Index Editor dialog.
To drop a table index:
- open the table in Table Editor;
- proceed to the Indices tab there;
- right-click the index and select the Drop Index context menu item;
- confirm dropping in the dialog window.