Table Indexes


An index is added to a table primararily to improve lookup performance for a table.

Add an Index to a Table:

In a Database Explorer window, right click the table node in the node tree to which you want to add an index.

In the popup menu, click Add Index.


Index Edit Dialog

Complete the dialog box that appears and click Ok.

Editing a Index:

In a Database Explorer window, click on the Tables node then the in the node tree.

Select the tree node representing the table containing the index to edit.

Now select the Indexes node in the node tree.

A grid of this table's indexes will be shown in the lower right of the Database Explorer window.

You can type directly into this grid to modify the indexes' definitions. Double clicking a row in the grid allows modification of the index through a dialog window.

Indexes can be removed by selecting the appropriate row(s) in the grid and clicking the Remove Index button.


See also:

Database Tables
Table Columns