From derby-user-return-2275-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon Oct 17 18:33:14 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 41569 invoked from network); 17 Oct 2005 18:33:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 17 Oct 2005 18:33:13 -0000 Received: (qmail 56538 invoked by uid 500); 17 Oct 2005 18:32:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 54855 invoked by uid 500); 17 Oct 2005 18:32:22 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 54173 invoked by uid 99); 17 Oct 2005 18:32:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Oct 2005 11:32:17 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.110.153] (HELO e35.co.us.ibm.com) (32.97.110.153) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Oct 2005 11:28:46 -0700 Received: from d03relay04.boulder.ibm.com (d03relay04.boulder.ibm.com [9.17.195.106]) by e35.co.us.ibm.com (8.12.11/8.12.11) with ESMTP id j9HIP3Ed029191 for ; Mon, 17 Oct 2005 14:25:03 -0400 Received: from d03av01.boulder.ibm.com (d03av01.boulder.ibm.com [9.17.195.167]) by d03relay04.boulder.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j9HITGTB532174 for ; Mon, 17 Oct 2005 12:29:16 -0600 Received: from d03av01.boulder.ibm.com (loopback [127.0.0.1]) by d03av01.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id j9HISNvS005656 for ; Mon, 17 Oct 2005 12:28:23 -0600 Received: from [127.0.0.1] (dyn9030040113.svl.ibm.com [9.30.40.113] (may be forged)) by d03av01.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j9HISMdd005605 for ; Mon, 17 Oct 2005 12:28:23 -0600 Message-ID: <4353ECBF.8080107@Sourcery.Org> Date: Mon, 17 Oct 2005 11:26:07 -0700 From: Satheesh Bandaram User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: How to update cardinality statistics References: <4353EA29.7070406@softhome.net> In-Reply-To: <4353EA29.7070406@softhome.net> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Take a look at Tuning Derby manual page: http://db.apache.org/derby/docs/10.1/tuning/ctunstats848901.html This provides several ways to update cardinality information. Satheesh Radovan Biciste wrote: > Hello, > I'm very new to derby. I was looking how to update cardinality > statistics. I have joins between tables with couple hundreds of rows > and about 600 thousands of rows. I'm using embedded server version > 10.1.1 .0. > Here is what I've found so far: > 1. UPDATE STATISTICS FOR TABLE mytable is giving me a syntax error. > Should work on Cloudscape though. > 2. SYSCS_UTIL.SYSCS_COMPRESS_TABLE should update statistics but does > not make too much sense as I do only inserts. It would take tooo much > time. > > Am I missing something ? > Thank you very much, > Radovan > > >