Derby
  1. Derby
  2. DERBY-4934

Provide automatic update and creation of index cardinality statistics (istat)

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.1.2
    • Component/s: SQL, Store
    • Labels:
      None
    • Bug behavior facts:
      Performance

      Description

      Derby has been having problems with stale index cardinality statistics causing performance degradation because the optimizer picks a sub-optimal plan.
      This master JIRA issue tracks the addition of a feature that will automatically update and create index cardinality statistics.

      Note: For brevity I have decided to call the the feature istat during development

        Issue Links

          Activity

          Kristian Waagan created issue -
          Kristian Waagan made changes -
          Field Original Value New Value
          Link This issue supercedes DERBY-3788 [ DERBY-3788 ]
          Kristian Waagan made changes -
          Link This issue supercedes DERBY-4771 [ DERBY-4771 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-5025 [ DERBY-5025 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-5086 [ DERBY-5086 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5132 [ DERBY-5132 ]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Affects Version/s 10.8.1.0 [ 12315561 ]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.2 [ 12316362 ]
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Kristian Waagan made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12539560 ] Default workflow, editable Closed status [ 12800787 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development