Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 79437 invoked from network); 29 Jun 2006 21:35:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Jun 2006 21:35:09 -0000 Received: (qmail 97470 invoked by uid 500); 29 Jun 2006 21:35:09 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 97442 invoked by uid 500); 29 Jun 2006 21:35:09 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 97431 invoked by uid 99); 29 Jun 2006 21:35:09 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jun 2006 14:35:09 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jun 2006 14:35:08 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 7A25D6ACA9 for ; Thu, 29 Jun 2006 22:34:47 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Thu, 29 Jun 2006 21:34:47 -0000 Message-ID: <20060629213447.3324.28273@ajax.apache.org> Subject: [Db-derby Wiki] Update of "HintsAndTips" by StanleyBradbury X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by StanleyBradbury: http://wiki.apache.org/db-derby/HintsAndTips ------------------------------------------------------------------------------ || ListTableNames || Data dictionary query to return table names and schemas || || || ListKeyIndexes || Data dictionary query to list the index names support Primary and Foreign Keys || || || DatabaseConsistencyCheck || Running SYSCS_UTIL.SYSCS_CHECK_TABLE on all tables in a database || || + || CheckingForIndexStatistics || Got Cardinality Statistics for your indexes? (and how to get them) || ||