CODEWITHSUNDEEP
progress-4glopenedge
user3854150
user3854150

Reputation: 19

Can a table have multiple primary indexes in progress openedge

Can a table have multiple primary indexes in progress open edge.

Upvotes: 0

Views: 1495

Answers (3)

idspispopd
idspispopd

Reputation: 404

A table can have multiple unique indexes, though. A primary index usually is (and should be) unique, but this is not enforced. (Just in case there is confusion about primary and unique indexes.)

Upvotes: 0

Vel
Vel

Reputation: 67

No. Each table can have only one primary index.

Upvotes: 0

Tim Kuehn
Tim Kuehn

Reputation: 3251

No - each table (and temp-table) has one and only one primary index.

This is also true for tables with "no" indexes defined for it - the db engine will make an index (based on recid?) for tables like that.

There is nothing very special about the designation "primary". It is a potential tie-breaker used when other index selection rules result in multiple possible index choices -- if everything else is equal the "primary" index will be used. It is also the default index used when various utilities are run. But beyond that there is no magic associated with the "primary" attribute.

Upvotes: 1

Related Questions