Progress
Database Design
Guide
Index-related Hints
- As the ratio of records that satisfy the query to total records decreases, the desirability of indexed access increases.
- A rule-of-thumb is fewer indexes per table with heavy update activity and limited access; 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 Progress server side, and the minimum required records are returned to the client.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |