[
https://issues.apache.org/jira/browse/DERBY-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13263300#comment-13263300
]
Mamta A. Satoor commented on DERBY-4115:
----------------------------------------
Hi Bryan, thanks for looking at the patch.
The syntax indeed is "ALL DROP STATISTICS". It pretty much mirrors what we have
implemented for updated statistics which has the internal syntax of "ALL UPDATE
STATISTICS". I am not sure why we chose it to be that way. May be it was easier
to implement it that way in the parser and since this is internal only syntax,
may be we decided to go ahead with "ALL UPDATE STATISTICS" rather than "UPDATE
ALL STATISTICS".
> 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, DERBY4115_patch2_diff.txt,
> DERBY4115_patch3_diff.txt, DERBY4115_patch4_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
