Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <12403476.1150133489865.JavaMail.jira@brutus>
Date: Mon, 12 Jun 2006 17:31:29 +0000 (GMT+00:00)
From: "Rick Hillegas (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-1397) Tuning Guide: Puzzling optimizer
 documentation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Tuning Guide: Puzzling optimizer documentation
----------------------------------------------

         Key: DERBY-1397
         URL: http://issues.apache.org/jira/browse/DERBY-1397
     Project: Derby
        Type: Bug

  Components: Documentation  
    Versions: 10.2.0.0    
    Reporter: Rick Hillegas
     Fix For: 10.2.0.0


 Selectivity and cardinality statistics
   Working with cardinality statistics
     When cardinality statistics are automatically updated

       "For other operations, Derby automatically updates statistics for the table and all indexes on the table if they are already exist. Those operations are:

   * (all indexes) When you execute SYSCS_UTIL.SYSCS_COMPRESS_TABLE.
   * (index only) When you drop a column that is part of a table's index; the statistics for the affected index are dropped, and statistics for the other indexes on the table are updated.
"

What does the second bullet mean? Derby doesn't let you drop a column from a table right now. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira