db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-737) SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist
Date Thu, 01 Dec 2005 00:54:30 GMT
SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist
-----------------------------------------------------------------------------

         Key: DERBY-737
         URL: http://issues.apache.org/jira/browse/DERBY-737
     Project: Derby
        Type: Improvement
  Components: SQL  
    Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0,
10.1.3.0, 10.1.2.2, 10.0.2.2    
    Reporter: Kathey Marsden
    Priority: Minor


There must be an entry in the SYSSTATISTICS table in order for the cardinality statistics
in SYSSTATISTICS to be created with SYSCS_UTIL.SYSCS_COMPRESS_TABLE 

SYSCS_UTIL.SYSCS_COMPRESS_TABLE  should create statistics if they don't exist.  The only way
to create them if the index was created on an empty table, seems to be to drop and recreate
the index after the table has been loaded.


The documentation will also need updating if this change is made.
http://db.apache.org/derby/docs/10.1/tuning/ctunstats57373.html

-- 
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