Re: Index usage stats.

paulhoward@home.com wrote: > > Is there any way I can get usage statistics on indexes. We have a number > of tables that look like indexes have been added carelessly and I am > sure many of them are not being used. I need to clean these up. Hi, I think for all detached indexes as well as for all fragmented tables there is a way. This will just work for IDS and only if you didn't disable the TABLE-statistics. dbaccess sysmaster - <<eiei select bufreads, pagwrites from sysptprof wheredbsname = "yourdatabase" and tabname = "yourindexname"; eiei If the value for "bufreads" is at least twice as much as "pagwrites", then it looks as if the index is used. Best regards, Stefan Weideneder