Indexes Usages

Good Morning, I’m having some issues with available free space on my instance! However I have a lot of indexes that i’m afraid that are unused on a daily bases even monthly! Can anyone help me on building a sql statement that searches the SYSMATER database in order to retrieve the indexes usage information? Thank in advanced Helder Jesus

I am not sure what version you are on but in version 11, but onstat -g ppf or sysmaster:sysptprof table tell you how many operations occur by index (or index fragment). John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 03/09/2010 03:22:40 AM: > [image removed] > > Indexes Usages [19278] > > HELDER JESUS > > to: > > ids > > 03/09/2010 03:24 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Good Morning, > > I’m having some issues with available free space on my instance! > > However I have a lot of indexes that i’m afraid that are unused on a daily > bases even monthly! > > Can anyone help me on building a sql statement that searches the SYSMATER > database in order to retrieve the indexes usage information? > > Thank in advanced Helder Jesus > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >