Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
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>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.