System table to tell me if index is used or not

I have a table and I would like to know if all of the indexes on it are being used or not. I queried the SYSPTPROF table and I was wondering what exactly am I looking at. What does ISREADS means vs BUFFREADS? If ISREADS is zero does that mean the index is not being used? What does it mean when BUFFREADS is greater than zero but ISREADS is zero. Any help would be appreciated. Thanks

ISReads are ISAM reads. Bufreads are how many times the index was = available in memory, versus pagreads - hen it had to hit disk to find = the page. Therefore logically, ISreads should be higher than buffreads IMHO, since an index needs to be read to be modified, I look for indices = which have a read count close to their write count as candidates for = deletion. j. On Dec 7, 2011, at 7:18 PM, PAUL MITSUUCHI wrote: > I have a table and I would like to know if all of the indexes on it = are being=20 > used or not. I queried the SYSPTPROF table and I was wondering what = exactly am=20 > I looking at. What does ISREADS means vs BUFFREADS? If ISREADS is zero = does=20 > that mean the index is not being used? What does it mean when = BUFFREADS is=20 > greater than zero but ISREADS is zero. Any help would be appreciated. = Thanks=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20