RE: How to find if some index is ever used?

TBLSPACE_STATS Will >===== Original Message From "Art S. Kagel & Family" <kagel@erols.com> ===== >Wendy Zheng wrote: >> >> Hello, Informix Users, >> >> I have a database that have be in use for a long time. Over times, there are >> more and more indexes are created on the tables. >> There should be some indexes that is no longer needed. >> But before dropping those indexes, I want to make sure they are not in use >> any more for a period of time (see a week). >> My question is: >> >> Is there any ways that I can find out if some index is ever used? >> >> The database is in production, it is not convenient/possible to gather all >> SQLs against the database and set explain to them to find out the indexes >> that are used. > >You could detach the indexes you suspect are no longer needed, turn on >tablspace stats (onconfig parameter TBLSPACESTATS ??) and use onstat to >see if there is any activity on the detached indexes partnums over >time. > >-- >Art S. Kagel & Family >kagel@erols.com ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------