[jira] [Updated] (DERBY-4115) Provide a way to drop statistics information

["Kathey Marsden (Updated) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-4115:
----------------------------------

    Issue & fix info: High Value Fix

>Has this feature never been implemented due to lack of demand, or are there potential issues that haven't been noted in this JIRA? 

I filed it in response to a specific user case where it would have been helpful.   Now with automatic index stat it is more needed.  I think it hasn't been picked up before now because folks just haven't had the bandwidth and it is not a bug so doesn't get reviewed often with triage. I think it would be a great addition and am marking it High Value Fix in case anyone finds that inspiring #:)
                
> 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
>
> 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