The Indexes Tab

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.

Figure 8.15 The Indexes Tab

Content is described in the surrounding text.

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 ASC or DESC under the Order column. Create an index prefix by specifying a numeric value under the Length 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 the Delete Selected Indexes menu item.

User Comments
Sign Up Login You must be logged in to post a comment.