db-derby-dev mailing list archives

[jira] Commented: (DERBY-737) SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist

Date

Mon, 16 Oct 2006 16:46:36 GMT

[ http://issues.apache.org/jira/browse/DERBY-737?page=comments#action_12442641 ]
Mamta A. Satoor commented on DERBY-737:
---------------------------------------
Bryan, thanks for committing the patch to the trunk. I think it will be useful to port this
patch to prior releases because optimizer relies on the statistics information for indexes
on a table. As for documentation, I will open another Jira entry for the doc changes.
> 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