Kbase P106895: What is the maximum of indexes for a SQL92 table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What is the maximum of indexes for a SQL92 table?
GOAL:
What is the maximum of columns for the indexes?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
FIX:
There is no limit for the number of indexes per table. The only limit which applies is of 32,767 indexes within a database (32K-1).
There is no explicit limit for the number of columns in an index. However an index key value is currently limited to about 200 bytes, so consequently an index cannot have more than around 100 components.