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.

 

 

Creating Indices

 

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.

 

Editing Indices

 

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.

 

Dropping Indices

 

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.