Progress
Basic Database
Tools
Creating an Index
Follow these steps to create an index:
- Choose Schema
Index Editor. Progress alphabetically lists all the tables defined for your database.
- Select a table.
- Choose the Add option from the bottom of the window:
![]()
- Enter a name for the index. Specify whether the index is unique or non-unique, active or inactive, and a word index or a standard index.
- Press RETURN. Progress displays the Adding Index window, which lists the field names you can add to the new index:
![]()
- Use the up and down arrow keys to move the highlight bar over the field names. To select a highlighted field, press RETURN. Progress prompts you to specify whether you want this index component to be ascending or descending.
- Specify Yes for ascending, No for descending. Progress moves the selected filed above the dividing line of the window. To change the sort order of a field above the dividing bar, highlight the field then press + for ascending and - for descending.
- Select the next field. You can specify up to 10 fields to define an index.
- When you are done choosing fields, press GO. If the index has a character field as the last index component, Progress prompts you to specify whether you want to use the Abbreviate option.
- Specify whether to use the Abbreviate option. Progress returns you to the Index Editor and adds the new index to the list.
- Choose Exit to apply the change. Progress displays an alert box asking if you want to apply or undo the changes to the database, or if you want to make other changes.
- Choose Apply Changes. Progress returns you to the Data Dictionary main window.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |