Release 10.1A: OpenEdge Getting Started:
Database Essentials

> ## Choosing which tables and columns to index

> If you perform frequent adds, deletes, and updates against a small table, you might not want to index it because of slower performance caused by the index overhead. However, if you mostly perform retrievals, then it is useful to create an index for the table. You can index the columns that are retrieved most often, and in the order they are most often retrieved.

> You do not have to create an index if you are retrieving a large percentage of the rows in your database (for example, 19,000 out of 20,000 rows). It is more efficient to scan the table. However, it is worth your while to create an index to retrieve a very small number of rows (for example, 100 out of 20,000). This way OpenEdge scans only the index table instead of the entire table.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095