Managing Table Indexes

You can access the Index Manager tool by right clicking a database table, and selecting the Menu option ‘Alter Table’ -> ‘Indexes’.

The Index Manager interface displays the list of indexes in the table on the left side. Selecting an index displays the list of fields (columns) of the table that are part of the index.

Clicking the ‘Edit Index’ button enables editing of the selected index. You can Add and delete fields from the index and then click the ‘Done’ button to update the changes you have made to the index. Please note that the changes are temporary and not commited until you press the ‘Save All Changes’ button. You can add more indexes, or edit as many times as you like before you save the changes. It is however, recommended for best results to make changes to one index and save it before applying changes to other indexes.