The following list contains index-related hints:

• As the ratio of records that satisfy the query to total records decreases, the desirability of indexed access increases.
• As a rule of thumb, use fewer indexes per table with heavy update activity and limited access; use more indexes per table with heavy access but limited update activity.
• Most index processing—including, for example, all word index evaluations—takes place on the OpenEdge server side, and the minimum required records are returned to the client.