Re: Update Statiscis in SPL
The proper answer to your short question is "It depends." However, I'll make a few assumptions and try to help you out. If the stored procedure (SP) runs fast then I would not mess with adding update stats to the SP. It's likely that the update statistics statements might just make the SP run longer due to the amount of time it takes to execute the update statistics statements. If the SP runs slow now, which I'll assume it does, then it would probably help to run update statistics on the temporary table after the data is loaded and indexes have been built. If you are not using indexes on the temp table then at least run update statistics low on the temp table. DL ----- Original Message ---- From: Juan Pablo <in4mixperu@hotmail.com> To: informix-list@iiug.org Sent: Monday, July 9, 2007 2:54:24 PM Subject: Update Statiscis in SPL Hi all: Within a SPL are created temporary tables, is recommendable that are sent to execute Update Statistics ? Thanks _________________________________________________________________ Sé uno de los primeros a testar el Windows Live Messenger beta. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
Just two notes: 1- The answer would be the same as for the same situation outside SPL. In other words, if you need them it's not because it's withing SPL 2- My be interesting to consider which version. If this is IDS 11, then most of the statistics you would need in temp tables are automatic. Regards DL Redden wrote: > The proper answer to your short question is "It depends." However, I'll > make a few assumptions and try to help you out. > > If the stored procedure (SP) runs fast then I would not mess with > adding update stats to the SP. It's likely that the update statistics > statements might just make the SP run longer due to the amount of time > it takes to execute the update statistics statements. > > If the SP runs slow now, which I'll assume it does, then it would > probably help to run update statistics on the temporary table after the > data is loaded and indexes have been built. If you are not using indexes > on the temp table then at least run update statistics low on the temp table. > > DL > > ----- Original Message ---- > From: Juan Pablo <in4mixperu@hotmail.com> > To: informix-list@iiug.org > Sent: Monday, July 9, 2007 2:54:24 PM > Subject: Update Statiscis in SPL > > Hi all: > > Within a SPL are created temporary tables, is recommendable that are > sent to > execute Update Statistics ? > > Thanks > > _________________________________________________________________ > S' uno de los primeros a testar el Windows Live Messenger beta. > http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...