db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-4115) Provide a way to drop statistics information
Date Tue, 24 Apr 2012 05:37:36 GMT

     [ 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

        

Mime
View raw message