Re: Update Statistics: Tell me the truth

From: dwilson@gtemail.net (Douglas Wilson) > >On Sat, 14 Oct 2000 13:41:14 GMT, "Z@forget.about.it" <Z@forget.about.it> >wrote: > > >When I ran updstats (thanks Art) on a database with about 1500 tables, it >choked. I believe some > >array reference was out of bounds because of the default size of some >data structure(s). > > > >Does anybody know what needs to be increased in the src code to allow for >this many tables? > >I don't know offhand, or even if there is such a limitation, but I'm sure >Art >could tell you. In the meantime though, you could try one of several >alternatives to 'dostats', including 'upd_stats' (a perl solution which >would >require DBI, DBD::Informix, and of course, perl. I assume you >already have ESQL/C). It's in the same general area of iiug: >http://www.iiug.org/software/index_DBA.html Or you can use mkupdstats, which only requires dbaccess... :-))) _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.