[ http://issues.apache.org/jira/browse/DERBY-737?page=comments#action_12442684 ] Bryan Pendleton commented on DERBY-737: ---------------------------------------
The merge to the 10.2 branch was straightforward, and my 10.2 derbyall test run was clean. I propose to commit this merged change to the 10.2 branch. > 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 > Issue Type: Improvement > Components: SQL > Affects Versions: 10.1.3.1, 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, > 10.2.1.6, 10.0.2.2 > Reporter: Kathey Marsden > Assigned To: Mamta A. Satoor > Priority: Minor > Attachments: DERBY737_v1_diff_SYSCS_COMPRESS_TABLE.txt, > DERBY737_v1_stat_SYSCS_COMPRESS_TABLE.txt > > > 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
