Re: onstat -t output

Posted in 1998

Art S. Kagel — Thu, 25 Jun 1998 13:45:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Sadagopan, Sathish wrote: > > Hi, > The point is , I have all the tables populated with a large number of tuples > , whereas 'nrows' of onstat -t shows zeroes.Any explanation for that ? Easy. The nrows field is not maintained live it is only uptdated if you run UPDATE STATISTICS at the table level either HIGH or MEDIUM (without the DISTRIBUTIONS ONLY clause) or LOW (with or without the DROP DISTRIBUTIONS clause). Looks like you are not running UPDATE STATISTICS regularly. Naughty! Art S. Kagel