Table Indexes
An index is added to a table usually to improve query performance.
Add an Index:
In Database Explorer, right click the table node in to which you want to add an index.
In the Details panel at the bottom of the screen select the Indexes tab. Then click the Add button.
Index Edit Dialog
Complete the dialog box that appears and click Ok.
Editing a Index:
In Database Explorer, select the tree node representing the table containing the index to edit.
Select the Indexes tab in the Details panel.
A grid of this table's indexes is shown.
You can type directly into this grid to modify the indexes' definitions. Double clicking a row in the grid allows modification of the index using a dialog window.
Indexes can be removed by selecting the appropriate row(s) in the grid and clicking the Remove button.
See also: