Informix Error -26950: Clustered compressed indexes are not supported.
Cause and resolution
Clustered compressed indexes are not supported.
Compressed indexes must be non-clustered indexes. After you create a clustered index, you can compress it using an SQL admin API command.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26950 fires when a compressed index is defined as clustered — per the official guidance.
- The compressed index is clustered, per the official guidance — the direct, only cause; compressed indexes must be non-clustered.
Solutions / Resolution
- Create the index as clustered first, then compress it via an SQL admin API command, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond compressing a clustered index directly.
Diagnostic Checks
- Check whether the index is clustered, and use the create-then-compress sequence instead of compressing a clustered index directly.
Related Errors / Related Topics
- -26904 — "Attached, non-vanilla or interval fragmented compressed indexes are not supported." A related compressed-index restriction, on attachment/fragmentation/type rather than clustering.
A compressed index was defined as clustered, which isn't supported — create it clustered first, then compress via the admin API.