Auto Update Statistics
Hi, I had found some "USTB" events in the Informix auditing log for a newly purchased application use ODBC calls to access the database, but the vendor said that they didn't include "UPDATE STATISTICS" statments in their coding. Can anyone have idea on this case? Is there "auto update statistics" option in Informix database? Best regards, Addams
There's no automatic UPDATE STATISTICS that I know of - much as I'd like there to be one. If I had my way, you'd never run them manually except if the system screwed up. That's what autonomic computing is about. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "ADDAMS AU" | | | <addamsau@pcihl.c| | | om> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 10/03/2003 02:16 | | | AM | |---------+----------------------------> >------------------------------------------------------------------------------- ----------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: Auto Update Statistics [1985] | >------------------------------------------------------------------------------- ----------------------------------------------------------------| Hi, I had found some "USTB" events in the Informix auditing log for a newly purchased application use ODBC calls to access the database, but the vendor said that they didn't include "UPDATE STATISTICS" statments in their coding. Can anyone have idea on this case? Is there "auto update statistics" option in Informix database? Best regards, Addams
How much overhead would that add to the system? -----Original Message----- From: Jonathan Le.... [mailto:jleffler@us.ibm.com] Sent: Friday, October 03, 2003 12:04 PM To: ids@iiug.org Subject: Re: Auto Update Statistics [1988] There's no automatic UPDATE STATISTICS that I know of - much as I'd like there to be one. If I had my way, you'd never run them manually except if the system screwed up. That's what autonomic computing is about. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "ADDAMS AU" | | | <addamsau@pcihl.c| | | om> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 10/03/2003 02:16 | | | AM | |---------+----------------------------> >--------------------------------------------------------------------------- --------------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: Auto Update Statistics [1985] | >--------------------------------------------------------------------------- --------------------------------------------------------------------| Hi, I had found some "USTB" events in the Informix auditing log for a newly purchased application use ODBC calls to access the database, but the vendor said that they didn't include "UPDATE STATISTICS" statments in their coding. Can anyone have idea on this case? Is there "auto update statistics" option in Informix database? Best regards, Addams "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."
ADDAMS AU wrote: >Hi, > >I had found some "USTB" events in the Informix auditing log for a newly purchased application use ODBC calls to access the database, but the vendor said that they didn't include "UPDATE STATISTICS" statments in their coding. Can anyone have idea on this case? >Is there "auto update statistics" option in Informix database? > > >Best regards, >Addams > We have made experiences with an automatic executed update statistics a few weeks ago. We made an update statistics for all tables excluding a few special ones. We use Art Kagels dostats for this job. Statistics for the procedures in the database where not updated then. The first time the procedure is used after the statistics update for the tables informix recognizes this and executes an update statistics for the current procedure. But I don't know, if this causes an entry in auditing log. Regards Frank Langelage