How to Define Additional Indexes

To define additional indexes:

1.	From the menu bar, choose Define, Additional Indexes.

The Indexes window appears.

2.	Define the index by specifying its name, and by specifying the table on which it must be created.

Click on the Columns tab to specify which columns are part of the index, and in which order.

For each of the columns that is to be part of the index:

·	Type a (sequence) number to indicate its order.

·	Type the name of the column. You can also click the Column lookup button and select one from the list that appears.

·	Choose Ascending, or Descending to indicate how the data in the column is to be ordered. The default value is Ascending.

3.	Save your changes in the database.

4.	Repeat the previous steps for all the additional indexes that you want to define.

5.	Choose Tools, Physical Tables, Create from the Definer menu, choose: Selected, and then explicitly select those tables on which you defined additional indexes. Do NOT choose the New or Updated option.

HINT:

When you define additional indexes on a table, it is a good idea to open the Tables window as well, and to execute a query that retrieves the data on the particular table. You will then be able to see what the various columns of that table are, and whether indexes have perhaps already been defined implicitly (the Key field in the Column box will then contain a numerical value).

NOTE:

USoft Developer allows you to document your application by writing descriptions or comments on indexes. With the required Indexes window open, click on the Comments tab. The Comment tab page appears. Enter your comments or description in the Comment field. Save your changes.