Re: systables.nrows vs count(*)

This is updated when you run UPDATE STATISTICS. I doubt you would want an extra update every time you inserted a row into a table? -Bill } } 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 } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net