db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1397) Tuning Guide: Puzzling optimizer documentation
Date Mon, 12 Jun 2006 17:31:29 GMT
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


Mime
View raw message