[
https://issues.apache.org/jira/browse/DERBY-737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12573364#action_12573364
]
Mamta A. Satoor commented on DERBY-737:
---------------------------------------
Merged changes into 10.1 codeline using revision 632065
> SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist
> -----------------------------------------------------------------------------
>
> Key: DERBY-737
> URL: https://issues.apache.org/jira/browse/DERBY-737
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0, 10.1.2.1,
> 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Mamta A. Satoor
> Priority: Minor
> Fix For: 10.2.2.0, 10.3.1.4
>
> 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.
-
You can reply to this email to add a comment to the issue online.
