You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2012/05/18 09:07:19 UTC
[jira] [Resolved] (DERBY-5770) Reduce window of opportunity for
queries being compiled without statistics on istat update
[ 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