IDS 9.4 and Indexes

Does anyone know how I can tell if an index is being utilized or not? I am in the process of re-orging several tables that have 6 or 7 indexes defined to them. I would like to be able to drop some of these and not create them again, but I do not know how to tell if a particular index has been used. Richard Ramsower Harris County - ITC Database Administrator wk#:713-368-0034; pager#:713-606-3511

Richard: They pieces of information I find useful when looking at indexes are: 1. sysmaster:sysptfprof or onstat -g ppf this will tell you how many locks and how many items have b= een read from this index. It currently will not tell you how m= any add or deletes. 2. onstat -C part. This will tell you three items. a) How many times we have position using this index b) How pages in this index have been compressed. c) How many index pages have been split Index Statistics =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Partnum Key Positions Compress Split 0x00100002 1 719 0 0 0x00100003 1 1635 0 6 0x00100003 2 1432 10 1 Hope this helps, John = "Ramsower, = Richard (ITC)" = <Richard.Ramsower = To @itc.hctx.net> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect IDS 9.4 and Indexes [10328] = = 11/07/2007 10:57 = AM = = = Please respond to = ids@iiug.org = = = Does anyone know how I can tell if an index is being utilized or not? I= am in the process of re-orging several tables that have 6 or 7 indexes defined to them. I would like to be able to drop some of these and not create them again, but I do not know how to tell if a particular index has been used. Richard Ramsower Harris County - ITC Database Administrator wk#:713-368-0034; pager#:713-606-3511 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =