Adding Indexes to a Synonym

Indexes are used to quickly locate data when a database table is queried, providing efficient access to ordered records. Indexes can be created using one or more columns of a database table.

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.

For WebFOCUS files, 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.

Example: Adding an Index to a Column

Right-click the field name .
In the Properties panel, select the I - Index check box.
Select Rebuild Data Source from the Data button on the Home tab to rebuild the data source.