[
https://issues.apache.org/jira/browse/DERBY-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13260706#comment-13260706
]
Mamta A. Satoor commented on DERBY-4115:
----------------------------------------
I forgot to mention in my earlier patch that I have given the new
routine(SYSCS_DROP_STATISTICS) public access (same as existing update
statistics procedure). This happens in DataDictionaryImpl, where
SYSCS_DROP_STATISTICS is added to the list of public access procedures in
sysUtilProceduresWithPublicAccess. Just wanted to bring this up since it is not
very obvious. Thanks
Also, please let me know if we should use a different name for this procedure.
I am using SYSCS_DROP_STATISTICS in the attached patch.
> Provide a way to drop statistics information
> --------------------------------------------
>
> Key: DERBY-4115
> URL: https://issues.apache.org/jira/browse/DERBY-4115
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Kathey Marsden
> Assignee: Mamta A. Satoor
> Attachments: DERBY4115_patch1_diff.txt
>
>
> Now that DERBY-269 has been resolved, users can update statistics, but once
> they do, they are committed to using and maintaining the statistics, even if
> it doesn't improve performance or they have difficulty maintaining the
> statistics on a regular basis. It would be good to have a way to drop
> statistics information so that users could revert to the prior behavior if
> needed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
