Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5770

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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
        knutanders Knut Anders Hatlen added a comment -

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

        Show
        knutanders Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.
        Hide
        kristwaa 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
        kristwaa 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
        kristwaa Kristian Waagan added a comment -

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

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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development