RE: An Update Statistics funny

Posted in 2004

Murray Wood (IList) — Fri, 21 May 2004 10:54:35 +1200 — source: Usenet: comp.databases.informix

How many of those tables have more than 1 row. I dont think sysdistrib is populated for tables with fewer that 2 (I think) rows. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of > chris.staubin@reebok.com > Sent: Friday, 21 May 2004 6:37 a.m. > To: malcolm weallans > Cc: informix-list@iiug.org; owner-informix-list@iiug.org > Subject: Re: An Update Statistics funny > > > How could you have let that happen? > > just kidding :-) > > > -Chris > > > > malcolm weallans <malcolm.iiug@btopenworld.com> > Sent by: owner-informix-list@iiug.org > 05/20/2004 11:42 AM > > To > informix-list@iiug.org > cc > > Subject > An Update Statistics funny > > > > > > > Every day this company runs UPDATE STATISTICS MEDIUM on the whole > database. There are about 1700 tables in the database. But when I check > in sysdistrib I can only find records for about 230 tables. > > IDS 9.30 > SUSE Linux SLES 8 > > Oh, and you've guessed it - they are cmplaining about performance. > > regards > > Malcolm > > sending to informix-list sending to informix-list