Re: systables.nrows vs count(*)

In article <5o35lt$41s@cssun.mathcs.emory.edu>, manoj@mailhost.twowaytv.co.uk (Manoj) wrote: > All, > When users insert into a table the nrows is not updated. > Is this normal ? > (informix 7.22 dsa /solaris 2.5.1) This is normal if you're talking about the systables table which doesn't get updated until you do an update statistics. However the sysmaster database (in versions 7.x) always has up-to-date information without having to update statistics. Look into the systabinfo table, as in: select ti_nrows from sysmaster:systabnames systabn, sysmaster:systabinfo systabi where systabn.tabname = ? and dbsname = ? and systabi.ti_partnum=systabn.partnum The oncheck utility also seems to retrieve current information. Best regards, one of all ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.rl.is/~john/pow4gl.html -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet