db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DERBY-5770) Reduce window of opportunity for queries being compiled without statistics on istat update
Date Fri, 18 May 2012 07:07:19 GMT

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

Kristian Waagan resolved DERBY-5770.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.9.0.0

Regression tests passed.
Committed patch 1a to trunk with revision 1339999.

Resolving issue, I don't expect more work on this.
                
> Reduce window of opportunity for queries being compiled without statistics on istat update
> ------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5770
>                 URL: https://issues.apache.org/jira/browse/DERBY-5770
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.9.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>            Priority: Minor
>             Fix For: 10.9.0.0
>
>         Attachments: derby-5770-1a-move_invalidation.diff
>
>
> Currently the invalidation of statements accessing a table is issued before dropping
the old statistics and writing new ones. While we cannot guarantee that all compilations will
see the new statistics (we can currently only drop all statistics for an index, so we cannot
add the new ones first and then drop the old ones), we can do the invalidation after the work
has been done to reduce the chances that queries are compiled without statistics at all.

--
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