Re: onstat -t output

Posted in 1998

Joe Lumbley — Thu, 25 Jun 1998 15:41:58 GMT — source: Informix-list mailing list archive (1991-1998)

Sadagopan, Sathish (sadagop0458@att.com) wrote: : Hi, : The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' : and : 'npdata' have non-zero values . Why is this so ? : TIA : Sathish Have you run update statistics against the database? Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998 from Prentice Hall/Informix Press. ---------------------------------------------------------------------------