progress 4gl

Posted by balaji on 29-Mar-2014 09:22

how many index can we use in a table?

how many fields added in per index?

All Replies

Posted by Dileep Dasa on 29-Mar-2014 09:48

The maximum number of indexes supported is 32,767, regardless of block size

Index entries have a maximum of 16 fields per index

Posted by Rob Fitzpatrick on 30-Mar-2014 12:19

You can define dozens of indexes per table.  But that doesn't mean that you should.  Each additional index on a table makes updates more expensive, not to mention maintenance activities like index compact, repair, rebuild, dump and load, etc.

Your database design should be guided by the needs of your application(s).  If you run up against an architectural limit here then you have probably done something wrong, i.e. your design is very inefficient.

Posted by Stefan Bolte on 15-May-2014 02:35

You may want to check out the summary of OpenEdge RDBMS limits.

This thread is closed