Re: sysmaster database

Posted in 1998

]Steve Berg — Wed, 15 Jul 1998 09:10:38 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

Are you using the sysmaster tables that are views? Maybe the non-view tables have better performance. I never tested it. Steve Berg spb@nb.com On Tue, 14 Jul 1998, Bill Weaver wrote: > I have several SQL's that I use to monitor my system via sysmaster. While this > method has never been terribly speedy, it seems that these SQL's are taking > longer and longer to complete. Is there something I can do to speed up queries > against sysmaster? Should "update statistics" be run against it regularly even > though most of the tables aren't "real" tables? Could there be a problem with > multiple extents and if so, how do you fix that in sysmaster? > -------------------------------------------------------- > Name: Bill Weaver > E-mail: Bill Weaver <billw@fscorp.com> > Date: 07/14/98 > Time: 08:20:59 > > This message was sent by Z-Mail Pro - from NetManage > NetManage - delivers Standards Based IntraNet Solutions > -------------------------------------------------------- > >