[
https://issues.apache.org/jira/browse/DERBY-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-4115:
-----------------------------------
Attachment: DERBY4115_patch1_diff.txt
This is first incremental patch(not ready for commit). It just has the very
basic prototype for a stored procedure which will eventually drop the
statistics for a given table or it's index. The procedure at this point just
has a println priting the parameters that were passed to it.
I have added one call to this procedure to make sure that it gets invoked
without any error.
Next, I plan to write upgrade test to make sure that this method will not be
available on pre-10.9 dbs, soft=upgraded dbs. It should only be available on
hard upgraded dbs.
> 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
