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

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

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.8.1.2
    • 10.8.1.2
    • SQL, Store
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: