Re: count(*) <> "wc -l" of unload file

Posted in 1998

jparker@epsilon.com — Fri, 10 Apr 1998 09:48:55 -0400 — source: Informix-list mailing list archive (1991-1998)

select count(*) will give you an accurate count of the number of records -regardless of statistics. You are thinking of: select nrows from systables where tabname = 'foo' which indeed is subject to recent statistics having been run. cheers j.