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
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.