To view which index is currently the primary index for a table, run a Detailed Table Report or a Quick Index Report. The primary index is flagged with a "p."

Note: A word index cannot be the primary index.

To change the primary index for a table:

  1. Choose Schema > Index Editor. The Index Editor alphabetically lists all the tables defined for your database.
  2. Select a table.
  3. Select the index you want to make primary.
  4. Choose Change Primary. The Index Editor prompts you to verify that you want to make the selected index the primary index for the table.
  5. Choose Yes to make the selected index the primary index for the table. The main window of the Index Editor reappears.
  6. Choose Exit. The Data Dictionary 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.
  7. Choose Apply Changes. The Data Dictionary main window appears.