sysptprof
Hi Can anyone confirm that if I wish to remove detached indexes that I think are not used, the isread field of sysptprof which show that information. If it is 0, doe that means the index is totally unused since the last reboot.
Or at least since the last time the stats were zero'd, yes. Actually you are unlikely to see zeros unless the table is completely staic, but, even if you see that isreads is about the same as iswrites, it is likely unused. The isreads will be significantly higher than iswrites if the index is being used. 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 Wed, Oct 17, 2012 at 5:42 AM, JIM GODDEN <jimgodden0@gmail.com> wrote: > Hi > > Can anyone confirm that if I wish to remove detached indexes that I think > are > not used, the isread field of sysptprof which show that information. If it > is > 0, doe that means the index is totally unused since the last reboot. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340bad73c9ad04cc3e4656
That's what I thought. Thanks for the very prompt response. regards Jim
The only piece of information I would add is that you are running a current version. In older releases (I forget the exact version) we did not track is isreads/iswrites/isdel on index fragments. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/17/2012 02:55:54 AM: > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org, > Date: 10/17/2012 02:56 AM > Subject: Re: sysptprof [28533] > Sent by: ids-bounces@iiug.org > > Or at least since the last time the stats were zero'd, yes. Actually you > are unlikely to see zeros unless the table is completely staic, but, even > if you see that isreads is about the same as iswrites, it is likely > unused. The isreads will be significantly higher than iswrites if the > index is being used. > > 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 Wed, Oct 17, 2012 at 5:42 AM, JIM GODDEN <jimgodden0@gmail.com> wrote: > > > Hi > > > > Can anyone confirm that if I wish to remove detached indexes that I think > > are > > not used, the isread field of sysptprof which show that information. If it > > is > > 0, doe that means the index is totally unused since the last reboot. > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --14dae9340bad73c9ad04cc3e4656 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >