Derby
  1. Derby
  2. DERBY-5770

Reduce window of opportunity for queries being compiled without statistics on istat update

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.1.0
    • Component/s: SQL
    • Labels:
      None

      Description

      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.

        Activity

        Hide
        Kristian Waagan added a comment -

        Attaching patch 1a, which moves the invalidation and removes the use of a boolean variable in invalidateStatements.

        Show
        Kristian Waagan added a comment - Attaching patch 1a, which moves the invalidation and removes the use of a boolean variable in invalidateStatements.
        Hide
        Kristian Waagan added a comment -

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

        Resolving issue, I don't expect more work on this.

        Show
        Kristian Waagan added a comment - Regression tests passed. Committed patch 1a to trunk with revision 1339999. Resolving issue, I don't expect more work on this.
        Hide
        Knut Anders Hatlen added a comment -

        [bulk update] Close all resolved issues that haven't been updated for more than one year.

        Show
        Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.

          People

          • Assignee:
            Kristian Waagan
            Reporter:
            Kristian Waagan
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development