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

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

    Details

    • Type: Task
    • Status: Closed
    • Priority: 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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: