You can create indexes in a synonym by adding them in the Synonym Editor. When you create a table using Data Management, Recreate DBMS table, the indexes are created in the relational data base.
When you use New, Synonym to create a synonym for a relational database table with more indexes than just the primary key, they will be included in the synonym.
Additional indexes are useful when you anticipate using a column in a JOIN operation, a WHERE condition, or as an argument to DB_LOOKUP. You can add multiple indexes. Each index can be on one or more columns. You can specify if the index is sorted, and whether it is a unique index.
This example uses the sample synonym ibisamp/dmreps that has a primary key on column REPNO and a unique index on that column. It shows how to add an index on the column EMPID, and another index on the FNAME and LNAME columns that does not have to be unique.
The Index Fields Editor dialog box opens. The field REPNO is already selected because it is the key column of the table.
The Index Fields Editor dialog box opens.
The Index Fields Editor dialog box opens.
Your synonym should look like the following image.
iWay Software |