Re: systables.nrows vs count(*)

Posted in 1997

Vince Pachiano — 16 Jun 1997 11:57:08 GMT — source: Informix-list mailing list archive (1991-1998)

Manoj <manoj@mailhost.twowaytv.co.uk> wrote in article <5o35lt$41s@cssun.mathcs.emory.edu>... > All, > > When users insert into a table the nrows is not updated. > > Is this normal ? > > (informix 7.22 dsa /solaris 2.5.1) > > thanks, > > > Manoj Schroff, Two Way TV Ltd, UK > +44(0)181 996 8221 > manoj@mailhost.twowaytv.co.uk > http://www.twowaytv.co.uk > > > Yes, Run "UPDATE STATISTICS FOR TABLE table-name Among other things, it updates systables, syscolumns, sysindexes -- Vince pachiano@dayton.bassinc.com "Opinions expressed may not be correct--- But at least they're my own !!! ;-)