Re: UPDATE STATISTICS

Posted in 1997

Manickam R Muthukumar — Thu, 09 Jan 1997 16:40:01 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, I guess it does not write outputfile. It is a good idea to run after a bulk load of data,also you can incorporate it with your daily archiving script that is before archiving you can run an Update Statistics. Hope this helps !! Cheers Patrick Stacey wrote: > > 1. Can someone tell me if the UPDATE STATISTICS command generates an > output file for the DBA to read? > > 2. How often should you run this procedure? > > TIA, > > /Patrick > TV Corp. Singapore -- ~~~~ SMILE !! increases the face value ~~~~~~~~~~~~~ M.R.Muthukumar Database Consultant Email:m_muthukumar@litle.net muthukumar@geocities.com http://www.geocities.com/SiliconValley/9956/ !! Strong believer in making things work !! (Opinion expressed here are mine only) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~