Adding a Custom Index

To add a custom index:

1. Open a record.

2. Select Tools, and then Data Administration, and then Indexes to access the Change Record Indexes dialog box.

3. Click Add Index.

   The Add Index dialog box enables you to determine for which database platforms you want to define the index if you selected the Some option for Platform. The system selects the Custom Key Order check box to ensure that the underlying record definition is not adversely affected by the change to your index.

   For all user-defined indexes, you must enter a description of the index in the Comments section. You should know the purpose of the index, the transactions and processes that use this index, and other relevant information. This information assists you when you want to remove unused indexes. An error message appears if you do not remove unused indexes.

   Note:

   You cannot add more than 22 user indexes (A–V). The system disables the Add Index button if the record already contains 22 user indexes.

4. Indicate the database platforms for which you want to create an index.

5. Click the OK button to add a row to the Change Record Indexes dialog box and to enable the arrow buttons.

6. Move the field under the new index row:

   1. In the Record Fields list box, select the field that you want indexed.

   2. Click the arrow button or double-click the field.

   3. Repeat this step for each field that you want to add.

7. Click OK.

8. Save the record definition.

9. Select Build, and then Current Project.

10. Select Create Indexes under Build Options.

    Make sure that you select the appropriate build settings.

11. Run the Build process to either generate a script or run SQL online.

12. Run the generated SQL script if you opted to generate one.

13. Confirm the construction of the new index with your native SQL command processor.