[
https://issues.apache.org/jira/browse/DERBY-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-5952:
-----------------------------------
Labels: derby_triage10_11 (was: )
> 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
> Labels: derby_triage10_11
>
> 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