Script to find indexes used

Does anybody have a routine to see if indexes on a table are used or has been ever used? Thanks Paul Mitsuuchi

Look at the sysmaster:sysptprof table. If the index's partnum has about equal reads and writes then it is likely not being accessed extensively except to maintain it against key changes and row inserts and deletes. If the reads are significantly higher than writes that is a good clue that the index is indeed being used by queries. Remember to allow for the IOs necessary for periodic UPDATE STATISTICS runs and also remember to check that the index you are about to drop wasn't added to make that one monthly or annual report run in a reasonable time. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 20, 2011 at 7:32 PM, PAUL MITSUUCHI < paul.mitsuuchi@digitalinsight.com> wrote: > Does anybody have a routine to see if indexes on a table are used or has > been > ever used? Thanks Paul Mitsuuchi > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf307cfcb6a287b704a888ebda