Re: Table has no rows but has lots of pages

Posted in 2004

Ferronato — 11 Mar 2004 05:02:54 -0800 — source: Usenet: comp.databases.informix

Hi, Try to use : oncheck -pT <database>:<table> > table.pT.outand analyse the output "table.pT.out". It can helps you ! Best regards. R. Ferronato fprose@hotmail.com (Fred Prose) wrote in message news:<195a4770.0403100639.2e262871@posting.google.com>... > Are you truely looking at just your tables? Remember, a detached > index (the default in 9.x) is going to have space (nptotal) with a row > count of 0 (nrows).