SMI - indexes and statistics

Hi all, I already see some some scripts where the people run update statistics over the SMI tables (tabid <= 99) and others create indexes for some tables, like sysusers... Is there a real advantage execute some of this actions? Or is just useless overhead to database ? Regards Cesar

Tables with tabids <= 99 are not SMI tables, they are system catalog tables. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar Inacio Martins Sent: Tuesday, April 26, 2011 7:52 AM To: ids@iiug.org Subject: SMI - indexes and statistics [23483] Hi all, I already see some some scripts where the people run update statistics over the SMI tables (tabid <= 99) and others create indexes for some tables, like sysusers... Is there a real advantage execute some of this actions? Or is just useless overhead to database ? Regards Cesar ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Dan, Yes, you right, I just make a little confusing with the names... Regards Cesar On 26/4/2011 08:55, Dan Mueller wrote: > Tables with tabids<= 99 are not SMI tables, they are system catalog tables. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar > Inacio Martins > Sent: Tuesday, April 26, 2011 7:52 AM > To: ids@iiug.org > Subject: SMI - indexes and statistics [23483] > > Hi all, > > I already see some some scripts where the people run update statistics over > the SMI tables (tabid<= 99) and others create indexes for some tables, like > sysusers... > > Is there a real advantage execute some of this actions? > Or is just useless overhead to database ? > > Regards > Cesar > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

We run update stats high on systabauth (grantee), even though grantee doesn't lead an index - On some of our systems this table has many hundred thousand records ... Since it doesn't lead an index my utility to do the update stats doesn't pick it up so it's hardcoded in ... If your system has many individual "grantors" (ours doesn't), you might want to update stats high on it also. John ----- Original Message ----- From: Cesar Inacio Martins To: ids@iiug.org Sent: Tuesday, April 26, 2011 8:20 AM Subject: [iiug] Re: SMI - indexes and statistics [23485] Hi Dan, Yes, you right, I just make a little confusing with the names... Regards Cesar On 26/4/2011 08:55, Dan Mueller wrote: > Tables with tabids<= 99 are not SMI tables, they are system catalog tables. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar > Inacio Martins > Sent: Tuesday, April 26, 2011 7:52 AM > To: ids@iiug.org > Subject: SMI - indexes and statistics [23483] > > Hi all, > > I already see some some scripts where the people run update statistics over > the SMI tables (tabid<= 99) and others create indexes for some tables, like > sysusers... > > Is there a real advantage execute some of this actions? > Or is just useless overhead to database ? > > Regards > Cesar > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Yes, if you have many objects in your database maintaining stats on the catalog tables can improve performance for some queries and for any app that queries the catalogs directly like dbschema and dbaccess. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Apr 26, 2011 at 8:20 AM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi Dan, > > Yes, you right, I just make a little confusing with the names... > > Regards > Cesar > > On 26/4/2011 08:55, Dan Mueller wrote: > > Tables with tabids<= 99 are not SMI tables, they are system catalog > tables. > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Cesar > > Inacio Martins > > Sent: Tuesday, April 26, 2011 7:52 AM > > To: ids@iiug.org > > Subject: SMI - indexes and statistics [23483] > > > > Hi all, > > > > I already see some some scripts where the people run update statistics > over > > the SMI tables (tabid<= 99) and others create indexes for some tables, > like > > sysusers... > > > > Is there a real advantage execute some of this actions? > > Or is just useless overhead to database ? > > > > Regards > > Cesar > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf305b0f1a95075104a1e870ff