Adding an index to a table definition

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Indices node for the table definition that you want to add the index to.
  3. Click the Indices node.
  4. Click Add above the grid.
  5. Type a name for the index in the Name field.
    Infor Public Sector typically uses NDX_[TABLENAME] followed by additional helpful information to name an index. You can use this naming scheme, or devise one of your own.
  6. In the Common ID field, type an identification code for the index according to your agency's naming scheme.
    You will use this common ID throughout Infor Public Sector to identify this index. Although the common ID is not required to be unique, making it unique will help you identify it later.
  7. Type a description of the index in the Description field.
    Descriptions, such as Index on [COLUMN_NAME], can help you identify the purpose of the index. The information you type should be helpful to anyone who will be setting up and maintaining Infor Public Sector.
  8. Specify any other information about the index.
  9. Under Linked Columns, click Add above the grid.
  10. In the Column field, specify the column that you want to link the index to.
    Click the popup button to the right of the Column field, select a column from the list that is displayed, and click Select. The list includes all columns from the current table that have not already been linked to this index.
  11. Click Save to save the link.
    Infor Public Sector shows the link in the Linked Columns grid.
  12. Click Save to save the index.
    Infor Public Sector assigns a key value to the index and adds the index to the table definition. The new index is displayed in the Indices grid. Note that changing or deleting an existing index will cause errors wherever it has already been used. If you change or delete an index, you must update any references to it throughout your system.