Summary

Note: Only Supervisors can modify user-defined indexes.

User-defined indexes speed up many operations within PayGlobal. You can define an index on most fields that are used frequently within queries or security queries. Indexes are limited to a single field.

Indexes slow down some operations, so only define indexes on fields that are used frequently. User-defined indexes are not likely to help for small tables of less than 1000 records. The only exception is the Employee table, where it may help having indexes if there are more than 100 employees.

For example, if you set up security based on the pay period of the employee, you should also define an index on PayPeriodCode for the Employee table to speed up loading of the system.