Using WinMySQL Professional

Add index

Only accessible when connected and when a table is active, the «Table management>Add index» submenu allows to enhance the current table access performance. Indeed, if a column is often accessed, you should index it. There is a required condition to be allowed to create an index on a column : this column must have been declared with the option «NOT NULL» ; if not, make this column «NOT NUL» with the «Table management>Make a column not null» submenu.

You may create all the indexes that you wish on a column (don't forget to reference it in the table definition of the table which must access to it). WinMySQL Professional names its generated indexes as follows : columnname_index ; for instance, an index on column «customer_id» will be called «customer_id_index» by WinMySQL Professional. If you want to give another name to your indexes, you must do it manually using the SQL pseudo-terminal (see the «Submenu File>New SQL query» section).

How to add an index to a column ?

Invoke the «Table management>Add index» submenu clicking on it or using the «Ctrl-F8» shortcut. Then, the «Columns list» screen appears. Select the column on which you wish apply the directive and click on the «Select» button. To complete the operation, confirm your choice.