An Update Statistics funny

Posted in 2004

Topics: Performance & Tuning, Platform-Specific Issues, Versions, Editions & End-of-Life

=?iso-8859-1?q?malcolm=20weallans?= — Thu, 20 May 2004 16:42:20 +0100 (BST) — source: Usenet: comp.databases.informix

--0-517746109-1085067740=:99890 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --0-517746109-1085067740=:99890 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit <DIV>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.</DIV> <DIV> </DIV> <DIV>IDS 9.30</DIV> <DIV>SUSE Linux SLES 8</DIV> <DIV> </DIV> <DIV>Oh, and you've guessed it - they are cmplaining about performance.</DIV> <DIV> </DIV> <DIV>regards</DIV> <DIV> </DIV> <DIV>Malcolm</DIV> --0-517746109-1085067740=:99890-- sending to informix-list

↪ replying to =?iso-8859-1?q?malcolm=20weallans?=

David Williams — Thu, 20 May 2004 19:18:28 +0100 — source: Usenet: comp.databases.informix

"malcolm weallans" <malcolm.iiug@btopenworld.com> wrote in message news:c8ilc3$5fc$1@terabinaries.xmission.com... > > --0-517746109-1085067740=:99890 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > 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. > Are there indexes on all the tables? > IDS 9.30 > SUSE Linux SLES 8 > > Oh, and you've guessed it - they are cmplaining about performance. Get Art Kagel's dostats + the Client SDK and run it on their system.. > > regards > > Malcolm > > --0-517746109-1085067740=:99890 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > <DIV>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.</DIV> > <DIV> </DIV> > <DIV>IDS 9.30</DIV> > <DIV>SUSE Linux SLES 8</DIV> > <DIV> </DIV> > <DIV>Oh, and you've guessed it - they are cmplaining about performance.</DIV> > <DIV> </DIV> > <DIV>regards</DIV> > <DIV> </DIV> > <DIV>Malcolm</DIV> > --0-517746109-1085067740=:99890-- > sending to informix-list

Related threads

Glossary

UPDATE STATISTICS