Chris Bullivant wrote:
>
> tabname ti_nrows ti_nptotal
>
> Table 1 0 8
> Table 2 0 1424
> Table 3 0 8
> Table 4 0 8
> Table 5 0 55296
> Table 6 0 8
> Table 7 0 8
> Table 8 0 4000
>
> What is happening here? How can a table have 0 rows in it and yet
> claim 55K pages? Am I interpreting the output correctly.

Simple. The rows of the above table were deleted. Informix does not release
the space when the row is deleted. Next time when rows are added in the above
tables, Informix will first use the existing pages (unless you load data via
HPL express mode).