Re: ANNOUNCE: Another update statistics utility - latest update

Douglas Wilson wrote: > On Mon, 20 Sep 1999, dwilson@gtemail.net (Douglas Wilson) wrote: > >At the IIUG repository at: > >http://www.iiug.org/software/index_DBA.html > > I've just attempted to add support for SE, email me or respond > here if it didn't work. > I've just noticed from the manual that SE doesn't take a > 'DISTRIBUTIONS ONLY' clause, so is it a syntax error, or > does it just accept it without complaint? Could someone let > me know please? I'd be surprised if SE accepted anything to do with distributions at all. It would accept: UPDATE STATISTICS; UPDATE STATISTICS FOR TABLE sometable; UPDATE STATISTICS FOR PROCEDURE someproc; I think that's all. That's all that's available for 5.x OnLine too. Note that the SE version of UPDATE STATISTICS is pretty quick in the absence of stored procedures -- it copies a number from the index file to the systables catalog and that's all. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>