Does the 16 million page limit apply to a single fragment index
There is a limit of 16775134 data pages per fragment in IBM Informix.
Is this also applicable to an index that resides in it's own single fragment?
Documentation does not indicate a limit for a dedicated fragment with index only.
No, there is no 16 million page limitation for a dedicated index fragment. However, the following limitations should be taken into consideration:
1) The dbspace page size
2) Index key size (for a given page size)
3) The ONCONFIG FILLFACTOR parameter
4) Sufficient free space in the dbspace dedicated for index storage
See related URL section for link to these limitations
Translate this page: