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] [Created] (DERBY-5770) Reduce window of opportunity for queries being compiled without statistics on istat update
Date Fri, 18 May 2012 05:55:02 GMT
Kristian Waagan created DERBY-5770:
--------------------------------------

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


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