The Indexes tab holds all index information for your table. Use this tab to add, drop, and modify indexes. The following figure shows an example of the layout.
Select an index by right-clicking it. The Index Columns section displays information about the selected index.
To add an index, click the last row in the index list. Enter a name for the index and select the index type from the list. Select the column or columns that you wish to index by checking the column name in the Index Columns list. You can remove a column from the index by removing the check mark from the appropriate column.
You can also specify the order of an index by choosing
DESC under the
Order column. Create an index prefix by
specifying a numeric value under the
column. You cannot enter a prefix value for fields that have a
data type that does not support prefixing.
To drop an index, right-click the row of the index you wish to delete, then select themenu item.