RE: update statistics on system tables

Posted in 2005

Topics: Versions, Editions & End-of-Life

Support Informix — Tue, 21 Jun 2005 06:20:12 — source: IIUG Forums & Mailing Lists

I'm still wondering : Should I update stats on system tables in sysmaster database or only on system tables in data database. Can somone explain me if it has sense ? Yves Dieltiens -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: 20 June 2005 17:13 To: ids@iiug.org Subject: Re: update statistics on system tables [5205] I always do ... at least once per week. YMMV. Take care. Clifton Anthony <ajudish@lextron-inc.com> wrote: IDS 9.4 on HPUX 11i Is it recommended to run update statistics on the system tables? ------_=_NextPart_001_01C57628.F7B7BB70 Content-Type: text/html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: update statistics on system tables </TITLE> </HEAD> <BODY> I'm still wondering : Should I update stats on system tables in sysmaster database or only on system tables in data database. Can somone explain me if it has sense ? Yves Dieltiens -----Original Message----- From: nobody@ace.iiug.org [<A HREF="mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] Sent: 20 June 2005 17:13 To: ids@iiug.org Subject: Re: update statistics on system tables [5205] I always do ... at least once per week.  YMMV.   Take care. Clifton Anthony <ajudish@lextron-inc.com> wrote: IDS 9.4 on HPUX 11i Is it recommended to run update statistics on the system tables? </BODY> </HTML> ------_=_NextPart_001_01C57628.F7B7BB70--

↪ replying to Support Informix

Khaled Bentebal — Tue, 21 Jun 2005 10:42:41 — source: IIUG Forums & Mailing Lists

HI, Update Statistics helps the optimizer to find the best possible route foryour queries. It is of course advisable to run it periodically depending on the volatility of the data in your tables. The sysmaster is a special database that contains pseudo-tables that represent memory structures for the post part. The statistics are set up in a special way (clued in at creation time) so that the optimizer doesn't change its path for the pseudo-tables in the sysmaster database.. Running UPDATE STATISTICS on the sysmaster database won't do anything. Hope that this helps. Khaled Bentebal ConsultiX Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: http://www.consult-ix.fr ----- Original Message ----- From: "Support Inf...." <supinformix@dofi.fgov.be> To: <ids@iiug.org> Sent: Tuesday, June 21, 2005 8:20 AM Subject: RE: update statistics on system tables [5212] > > I'm still wondering : > Should I update stats on system tables in sysmaster database > or only on system tables in data database. > Can somone explain me if it has sense ? > > Yves Dieltiens > > -----Original Message----- > From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] > Sent: 20 June 2005 17:13 > To: ids@iiug.org > Subject: Re: update statistics on system tables [5205] > > I always do ... at least once per week. YMMV. > > Take care. > Clifton > > Anthony <ajudish@lextron-inc.com> wrote: > IDS 9.4 on HPUX 11i > > Is it recommended to run update statistics on the system tables? > > > > ------_=_NextPart_001_01C57628.F7B7BB70 > Content-Type: text/html > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> > <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> > <TITLE>RE: update statistics on system tables </TITLE> > </HEAD> > <BODY> > > > I'm still wondering : > Should I update stats on system tables in sysmaster database > or only on system tables in data database. > Can somone explain me if it has sense ? > > > Yves Dieltiens > > > -----Original Message----- > From: nobody@ace.iiug.org [<A HREF="mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] > Sent: 20 June 2005 17:13 > To: ids@iiug.org > Subject: Re: update statistics on system tables [5205] > > > I always do ... at least once per week.  YMMV. >   > Take care. > Clifton > > > Anthony <ajudish@lextron-inc.com> wrote: > IDS 9.4 on HPUX 11i > > > Is it recommended to run update statistics on the system tables? > > > > </BODY> > </HTML> > ------_=_NextPart_001_01C57628.F7B7BB70-- > > > >

↪ replying to Support Informix

gerd kaluzinski — Tue, 21 Jun 2005 11:00:56 — source: IIUG Forums & Mailing Lists

Most of the table in sysmaster database are pseudotables, so update statistics does not help and update statistics high is often not permitted. On your local system tables in the databases, update statistics is implizit done when you simply call "update statistics". gerd "Support Inf...." <supinformix@dofi.fgov.be> schrieb am 21.06.05 08:29:56: > > > I'm still wondering : > Should I update stats on system tables in sysmaster database > or only on system tables in data database. > Can somone explain me if it has sense ? > > Yves Dieltiens > > -----Original Message----- > From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] > Sent: 20 June 2005 17:13 > To: ids@iiug.org > Subject: Re: update statistics on system tables [5205] > > I always do ... at least once per week. YMMV. > > Take care. > Clifton > > Anthony <ajudish@lextron-inc.com> wrote: > IDS 9.4 on HPUX 11i > > Is it recommended to run update statistics on the system tables? > > > > ------_=_NextPart_001_01C57628.F7B7BB70 > Content-Type: text/html > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> > <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> > <TITLE>RE: update statistics on system tables </TITLE> > </HEAD> > <BODY> > > > I'm still wondering : > Should I update stats on system tables in sysmaster database > or only on system tables in data database. > Can somone explain me if it has sense ? > > > Yves Dieltiens > > > -----Original Message----- > From: nobody@ace.iiug.org [<A HREF="mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] > Sent: 20 June 2005 17:13 > To: ids@iiug.org > Subject: Re: update statistics on system tables [5205] > > > I always do ... at least once per week.  YMMV. >   > Take care. > Clifton > > > Anthony <ajudish@lextron-inc.com> wrote: > IDS 9.4 on HPUX 11i > > > Is it recommended to run update statistics on the system tables? > > > > </BODY> > </HTML> > ------_=_NextPart_001_01C57628.F7B7BB70-- > > > ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193

Glossary

UPDATE STATISTICS