From derby-dev-return-94598-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Mon Apr 2 08:16:57 2012 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 C9F759996 for ; Mon, 2 Apr 2012 08:16:57 +0000 (UTC) Received: (qmail 11715 invoked by uid 500); 2 Apr 2012 08:16:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 11690 invoked by uid 500); 2 Apr 2012 08:16:57 -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 11653 invoked by uid 99); 2 Apr 2012 08:16:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 08:16:56 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 08:16:53 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id C40993533C2 for ; Mon, 2 Apr 2012 08:16:32 +0000 (UTC) Date: Mon, 2 Apr 2012 08:16:32 +0000 (UTC) From: "Kristian Waagan (Commented) (JIRA)" To: derby-dev@db.apache.org Message-ID: <1867708245.4698.1333354592804.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-4115) Provide a way to drop statistics information 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-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244029#comment-13244029 ] Kristian Waagan commented on DERBY-4115: ---------------------------------------- This seems like a simple system procedure to implement, and could be useful now that automatic updates of index cardinality statistics is enabled by default. We just saw a user report where the statistics were messed up due to a bug in Derby, and this caused the istat daemon to go crazy. A bug in the daemon itself would also be easier to work around if it is possible to discard existing statistics after the daemon has been disabled. Has this feature never been implemented due to lack of demand, or are there potential issues that haven't been noted in this JIRA? > Provide a way to drop statistics information > -------------------------------------------- > > Key: DERBY-4115 > URL: https://issues.apache.org/jira/browse/DERBY-4115 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.6.1.0 > Reporter: Kathey Marsden > > Now that DERBY-269 has been resolved, users can update statistics, but once they do, they are committed to using and maintaining the statistics, even if it doesn't improve performance or they have difficulty maintaining the statistics on a regular basis. It would be good to have a way to drop statistics information so that users could revert to the prior behavior if needed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira