Re: Re: Update Statistics - Questions

Posted in 2003

Topics: Performance & Tuning, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

WOLFGANG NEUMAR — Thu, 08 May 2003 08:54:38 — source: IIUG Forums & Mailing Lists

Hi! I actually do a lot of work with Informix migration to IDS9.30 and analyses with performance. When I have to run "update statistics low drop distributions"? When I have to run "update statistics low" or " medium/high"? When run "update statistics" every night on our databases. When I run "update statistics low drop distributions" it tooks a very long time. Are there any possibilities to speed up this job ( I have read something with PDQ???? )? IDS 9.30FC3X3 Unix Tru64 5.1B Regards Wolfgang

↪ replying to WOLFGANG NEUMAR

Support Informix — Fri, 09 May 2003 19:57:22 — source: IIUG Forums & Mailing Lists

You have to run update stats against the tables where indexes, or data has changed. Using PDQPRIORITY could be a good idea. Document http://www.iiug.org/iuc2002_pdf/d13.pdf discuss update stats and handles also PDQPRIORITY for stats. But don't use it for update stats for procedure because PDQPRIORITY will be stored in the procedure, so later when executing the procedures everyone has this PDQPRIORITY and everyone try to catch enough resources. And this can cause very much problems. I've the experience. (See also performance guide) On the other hand you could find on the IIUG site a program 'dostats' that do very well the work for you and there exists a script that allow to start multiple 'dostats' program in parallel. Very efficient on multi-processors. Yves -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: donderdag 8 mei 2003 10:55 To: ids@iiug.org Subject: Re: Re: Update Statistics - Questions [1094] Hi! I actually do a lot of work with Informix migration to IDS9.30 and analyses with performance. When I have to run "update statistics low drop distributions"? When I have to run "update statistics low" or " medium/high"? When run "update statistics" every night on our databases. When I run "update statistics low drop distributions" it tooks a very long time. Are there any possibilities to speed up this job ( I have read something with PDQ???? )? IDS 9.30FC3X3 Unix Tru64 5.1B Regards Wolfgang ------_=_NextPart_001_01C315F8.030F1A60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Re: Update Statistics - Questions [1094] </TITLE> </HEAD> <BODY> You have to run update stats against the tables where = indexes, or data has changed. Using PDQPRIORITY could be a good idea. Document <A = HREF=3D"http://www.iiug.org/iuc2002_pdf/d13.pdf"; = TARGET=3D"_blank">http://www.iiug.org/iuc2002_pdf/d13.pdf</A>; discuss = update stats and handles also PDQPRIORITY for stats. But don't use it for update stats for procedure = because PDQPRIORITY will be stored in the procedure, so later when = executing the procedures everyone has this PDQPRIORITY and everyone try = to catch enough resources. And this can cause very much problems. I've = the experience. (See also performance guide) On the other hand you could find on the IIUG site a = program 'dostats' that do very well the work for you and there exists a = script that allow to start multiple 'dostats' program in parallel. Very = efficient on multi-processors. Yves -----Original Message----- From: nobody@ace.iiug.org [<A = HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>]</FON= T> Sent: donderdag 8 mei 2003 10:55 To: ids@iiug.org Subject: Re: Re: Update Statistics - Questions = [1094] Hi! I actually do a lot of work with Informix migration = to IDS9.30 and analyses with performance. When I have to run "update statistics low drop = distributions"? When I have to run "update statistics low" = or " medium/high"? When run "update statistics" every night = on our databases. When I run "update statistics low drop = distributions" it tooks a very long time. Are there any possibilities to speed up this job ( I = have read something with PDQ???? )? IDS 9.30FC3X3 Unix Tru64 5.1B Regards Wolfgang </BODY> </HTML> ------_=_NextPart_001_01C315F8.030F1A60--

Related threads

Glossary

UPDATE STATISTICS