Re: UPDATE STATISTICS

Tim Schaefer wrote: > > Belakimem wrote: > > > > Why doesn't the engine UPDATE STATISTICS automatically? > > > > Does anyone have any ideas regarding the logistics of running of UPDATE > > STATISTICS in a 24 hour environment? > > > > Yes, run it after midnight, but before 1:00 am. > > :-) > > > Thank you and please also reply via email. > > I'll be presenting a new tool to use with 7.x update statistics in the > May issue of my ezine. You can find it at the URL listed below. > > Stay tuned. As a follow up, I corrected the source code to one of the little programs mentioned in my article, calctime.ec. Thanks to Jonathan for pointing out this little error. One benefit to fixing it, I used ESQL/C on Windows NT, and MS VC 2.0 to compile it, and it works as good as the UNIX compile I originally started out with. The bug? If you passed it the datetime values out of order, it would error out. Now it calculates any which way... You can find this article and the tools at my site listed in my sig. Just head to the May Issue of my ezine, and it'll be there. There's also a 4GL program for you to use, contributed by Richard Standford. I think you'll like it. Enjoy! ( I just love this internet collaboration stuff. ) :-) -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) ------------------------oOOo---( )---o00o--------- http://www.mindspring.com/~tschaefe http://www.inxutil.com ( http://207.69.204.52 )