db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5952) Need a way to determine which indexes are not used over the course of a week
Date Tue, 16 Apr 2013 16:13:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13632952#comment-13632952
] 

Mike Matrigali commented on DERBY-5952:
---------------------------------------

Derby provides ways to log the execution plans of every query executed.  Then user could look
at this out put and parse it to get 
the info.  There is overhead to this, and likely not what the request is looking for.
                
> 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

Mime
View raw message