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

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development