Re: UPDATE STATISTICS

On Wed, 30 Apr 1997, Ian Goddard wrote: > David Williams wrote: > > Write scripts to do these and break down the task of doing the whole > > database into several scripts. Each one can be run during 'quiet' > > time on the system. > Alternatively as 4GL or ESQL. Take the names of tables and procs out of > the system catalogue tables. That way your program becomes aware of new > targets to update and you don't have to maintain scripts. As an aside, there's a copy of a .4gl program to do just this at the column level (to Informix specs) out on the InxUtil site. It's in this month's magazine copy. BTW: The current version should be 4.2 -- I've sent an update in and it may not be updated online yet. If not, and you'd like a fresh copy, send me an email and let me know. -Richard