Informix Error -25898: The total size of the index exceeds 32767 bytes.
Cause and resolution
The total size of the index exceeds 32767 bytes.
The size of the composite index cannot exceed 32767 bytes. Consider reducing the number of index parts until this requirement is met.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25898 fires when a composite index's total size exceeds 32767 bytes — per the official guidance.
- A composite index with too many parts, exceeding 32767 bytes total, per the official guidance — the direct, only cause.
Solutions / Resolution
- Reduce the number of index parts until the total size fits within 32767 bytes, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an oversized composite index.
Diagnostic Checks
- Check the composite index's total encoded size, and reduce the number of index parts if it exceeds 32767 bytes.
Related Errors / Related Topics
- -25849 — "The indexkey size exceeds the catalog column size." A related index-key-size error, on a functional index's catalog storage limit rather than a composite index's overall size.
A composite index exceeded the 32767-byte total size limit — reduce the number of index parts.