Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.