Kbase P136000: What are the limits for a Word Index in OpenEdge 10.1B and 10.1C?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/17/2008 |
|
Status: Unverified
GOAL:
What are the limits for a Word Index in OpenEdge 10.1B and 10.1C?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
FIX:
? Index size has the following constraints:
NOTE: The 2000 character limit includes storage overhead, the actual index key is limited to approximately 1970 characters.
10.1B and higher:
New databases with 4K and 8K block sizes:
Total variable-length storage requirements of all fields in an index entry must be less than 2000 characters.
Example: A single field record limit for a word index would be < 1970 characters.
New databases with 1K and 2K block sizes:
Adhere to the previous index entry size of approximately 200 characters.
10.1C and higher:
Adhere to the previous index entry size of approximately 200 characters unless explicitly enabled to accept larger index entries.