Re: unused indexes

You can also use onstat -C part. While it doesn't have a timestamp, it tells you how often an index has been used since the instance was last cycled. ----- Original Message ---- From: Fernando Nunes <spam@onlinedomus.net> To: informix-list@iiug.org Sent: Monday, March 31, 2008 4:15:55 PM Subject: Re: unused indexes tomcaml@gmail.com wrote: > howdy > > does informix have system views/meta data that indicates the last time > an index was used? > > thanks > tom Directly no... But if your indexes are detached (they should be) you can look at their partition stats. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list