Progress
Database Design
Guide


Why Define an Index?

There are four significant benefits to defining an index for a table:

NOTE: Although an index imposes order on rows, the data stored on disk is in the order in which it was created. So, you can have multiple indexes on a table each providing a different sort ordering, the physical storage order is not controlled by the indexes.


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