Progress
Database Design
Guide


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 on the columns that are retrieved most often, and in the order they are most often retrieved.

You don’t 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 Progress scans only the index table instead of the entire table.


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