db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dwight Carter (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5952) Need a way to determine which indexes are not used over the course of a week
Date Tue, 16 Oct 2012 19:43:03 GMT
Dwight Carter created DERBY-5952:
------------------------------------

             Summary: 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
            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

Mime
View raw message