Does the 16 million page limit apply to a single fragment index

Technote (FAQ)


Question

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?

Cause

Documentation does not indicate a limit for a dedicated fragment with index only.

Answer

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


Related information

Table Level Limits

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1623754

Modified date:

2013-02-20

Translate my page

Machine Translation

Content navigation