[ https://issues.apache.org/jira/browse/DERBY-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-5952: ---------------------------------- Component/s: Store SQL > Need a way to determine which indexes are not used over the course of a week > ---------------------------------------------------------------------------- > > Key: DERBY-5952 > URL: https://issues.apache.org/jira/browse/DERBY-5952 > Project: Derby > Issue Type: Improvement > Components: SQL, Store > Reporter: Dwight Carter > Priority: Minor > > We have a derby database used by a rather complex codebase. Over time, > numerous indexes have been created on the tables. We'd like to delete > indexes which are no longer used, but don't know how to determine that. It > would be very useful if derby provided a way to get a list of indexes on a > database which have not been used in a period of time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira