Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 71589 invoked from network); 11 Mar 2010 00:16:22 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 11 Mar 2010 00:16:22 -0000 Received: (qmail 35979 invoked by uid 500); 11 Mar 2010 00:15:51 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 35925 invoked by uid 500); 11 Mar 2010 00:15:50 -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 35908 invoked by uid 99); 11 Mar 2010 00:15:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Mar 2010 00:15:50 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Mar 2010 00:15:48 +0000 Received: from brutus.apache.org (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 636C4234C4C2 for ; Thu, 11 Mar 2010 00:15:27 +0000 (UTC) Message-ID: <1103301234.192941268266527406.JavaMail.jira@brutus.apache.org> Date: Thu, 11 Mar 2010 00:15:27 +0000 (UTC) From: "Kathey Marsden (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-737) SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist In-Reply-To: <958154311.1133398470339.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-737: --------------------------------- Fix Version/s: 10.1.3.2 updating fix version to reflect 10.1 fix > SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist > ----------------------------------------------------------------------------- > > Key: DERBY-737 > URL: https://issues.apache.org/jira/browse/DERBY-737 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6 > Reporter: Kathey Marsden > Assignee: Mamta A. Satoor > Priority: Minor > Fix For: 10.1.3.2, 10.2.2.0, 10.3.1.4 > > Attachments: DERBY737_v1_diff_SYSCS_COMPRESS_TABLE.txt, DERBY737_v1_stat_SYSCS_COMPRESS_TABLE.txt > > > There must be an entry in the SYSSTATISTICS table in order for the cardinality statistics in SYSSTATISTICS to be created with SYSCS_UTIL.SYSCS_COMPRESS_TABLE > SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they don't exist. The only way to create them if the index was created on an empty table, seems to be to drop and recreate the index after the table has been loaded. > The documentation will also need updating if this change is made. > http://db.apache.org/derby/docs/10.1/tuning/ctunstats57373.html -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.