RES: why 'update statistics' run so fast in IDS9.4?

Posted in 2004

Tarcisio Gouveia — Thu, 1 Apr 2004 09:57:54 -0300 — source: Usenet: comp.databases.informix

That a look at update statistics log. -----Mensagem original----- De: curtis@crowson1.com [mailto:curtis@crowson1.com] Enviada em: quarta-feira, 31 de mar'o de 2004 16:49 Para: informix-list@iiug.org Assunto: Re: why 'update statistics' run so fast in IDS9.4? KS_Rogher@acer.com (roger huang) wrote in message news:<5d62ba00.0403310149.dc94c5@posting.google.com>... > Hi > Is any one know why IDS 9.4 running 'update statistics' so fast ? > I executed this SQL command and it finished immediately. > I doubt whether it do the same works as old version IDS. > It take a few hours to get through it in earlier IDS versions. This article might help explain it. http://www-106.ibm.com/developerworks/db2/zones/informix/library/techarticle /miller/0203miller.html#section2 sending to informix-list

Related threads

IDS not writing to online.log
RE: How to find usage for sbspace
Writing an iterator function in SPL
log files location