Kbase 20477: What is the upper limit on the number of indexes allowed for vesion 8?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What is the upper limit on the number of indexes allowed?
FACT(s) (Environment):
Progress 8.x
FIX:
You can have a different number of indexes depending on the database block size. At the most you can have 32 index anchor blocks.
The reason the number of indexes varies by block size is that the locations of the index root blocks are held in index anchor blocks that can hold a different number of entries depending on the block size.
A 1K block size allows for a little more than 6400 indexes, for example. An 8K block size allows a bit more than 32000 indexes.