Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C6423F9C1 for ; Tue, 16 Apr 2013 16:13:16 +0000 (UTC) Received: (qmail 727 invoked by uid 500); 16 Apr 2013 16:13:16 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 690 invoked by uid 500); 16 Apr 2013 16:13:16 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 565 invoked by uid 99); 16 Apr 2013 16:13:16 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Apr 2013 16:13:16 +0000 Date: Tue, 16 Apr 2013 16:13:16 +0000 (UTC) From: "Mike Matrigali (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-5952) Need a way to determine which indexes are not used over the course of a week MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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