Progress
Programming
Handbook


Defining Indexes for Temporary Tables

You can define indexes explicitly for temporary tables or you can inherit indexes from existing database tables. When you define a temporary table to be LIKE a database table, the temporary table inherits index layouts from the LIKE table according to these rules:

The following is a summary of the rules that determine the primary index of a temporary table.

  1. If you specify AS PRIMARY or IS PRIMARY for an index, then that is the primary index.
  2. If you do not specify AS PRIMARY or IS PRIMARY, but you inherit the primary index from a database table, that index is the primary index.
  3. If neither Rule 1 nor Rule 2 applies, then the first index you specify, if any, is the primary index, unless it is a word index, in which case it can’t be primary.
  4. If you have not specified any index information, then Progress creates a default primary index that sorts the records in entry order.

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