Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 18408 invoked from network); 24 Mar 2009 12:59:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 24 Mar 2009 12:59:24 -0000 Received: (qmail 38656 invoked by uid 500); 24 Mar 2009 12:59:24 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 38597 invoked by uid 500); 24 Mar 2009 12:59:24 -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 38589 invoked by uid 99); 24 Mar 2009 12:59:24 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Mar 2009 12:59:24 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [68.142.198.206] (HELO smtp107.sbc.mail.mud.yahoo.com) (68.142.198.206) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 24 Mar 2009 12:59:15 +0000 Received: (qmail 5764 invoked from network); 24 Mar 2009 12:58:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=VvQUSw5+R/SrvDyYvos96W9CuX4XheBijciuO+O6VEuk6qmD62Q/O0QNZwmto9KN1SG2LLi7HSQgaSMZ8HLJq9G0Du7pjgMzzhITU5W61kpSeqH0ZYY6lif0Zi+BjDc2mgo+VP3roxoPmgZy+bL8cn4g4Wbm64uicLpFXZyInGY= ; Received: from unknown (HELO ?192.168.1.101?) (kmarsdenderby@70.137.150.125 with plain) by smtp107.sbc.mail.mud.yahoo.com with SMTP; 24 Mar 2009 12:58:51 -0000 X-YMail-OSG: 6ZvhCXUVM1m1mDcXxXIfqHD.VlXcpnuL8XjDLHscadaURxOjnzwtM.8il8TADUb5bT3conpKJkz9sO_0Qg4W7V0VkzmGts_.BpDwf20yad0HyBccKlzBJ3fojuNbWAON3bOniPcx6gxZH3C8wBLa.cEw4R.jgXB.BGU69TdDTgSsG7iIYwQ2Ur1At5E- X-Yahoo-Newman-Property: ymail-3 Message-ID: <49C8D909.9070109@sbcglobal.net> Date: Tue, 24 Mar 2009 05:58:49 -0700 From: Kathey Marsden User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Derby Development Subject: Can I clear statistics? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org If I update (enable) statistics on a table and then find performance is worse or decide it is not worth the trouble having to update them periodically, is there a way to clear statistics so that I can go back to the original plan selection or am I committed to using statistics and updating periodically once I update them once? Thanks Kathey