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

Continue investigation of automatic creation/update of index statistics

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.8.1.2
    • 10.8.1.2
    • SQL, Store
    • None

    Description

      Work was started to improve Derby's handling of index statistics. This issue tracks further discussion and work for this task.

      Attachments

        1. autoindexstats.html
          2 kB
          Kristian Waagan
        2. derby.log
          37 kB
          Lily Wei
        3. derby-4771-1a-prototype_code_dump.diff
          48 kB
          Kristian Waagan
        4. derby-4771-1a-prototype_code_dump.stat
          1 kB
          Kristian Waagan
        5. derby-4771-1b-prototype_code_dump.diff
          49 kB
          Kristian Waagan
        6. derby-4771-2a-prototype_lcc_code_dump.diff
          79 kB
          Kristian Waagan
        7. derby-4771-2b-prototype_lcc_code_dump.diff
          59 kB
          Kristian Waagan
        8. derby-4771-2c-prototype_lcc_code_dump.diff
          99 kB
          Kristian Waagan
        9. derby-4771-2d-prototype_lcc_code_dump.diff
          105 kB
          Kristian Waagan
        10. derby-4771-2e-prototype_lcc_code_dump.diff
          108 kB
          Kristian Waagan
        11. DERBY-4771-2e-prototype.rar
          6.70 MB
          Lily Wei
        12. Derby-4771-2f-AutomaticIndexStatisticsTest_wondows7.rar
          1.59 MB
          Lily Wei
        13. derby-4771-2f-prototype_lcc_code_dump.diff
          119 kB
          Kristian Waagan
        14. derby-4771-2f-prototype_lcc_code_dump-WORK-IN-PROGRESS.diff
          126 kB
          Kristian Waagan
        15. derby-4771-2g-prototype_lcc_code_dump.diff
          129 kB
          Kristian Waagan
        16. derby-4771-2h-prototype_lcc_code_dump.diff
          135 kB
          Kristian Waagan
        17. error-stacktrace.out
          3 kB
          Lily Wei
        18. rjall.out
          1.37 MB
          Lily Wei
        19. rjall.out
          796 kB
          Lily Wei
        20. rjall.out
          3.05 MB
          Lily Wei
        21. rjall.rar
          764 kB
          Lily Wei
        22. rjone.out
          17 kB
          Lily Wei

        Issue Links

          incorporates

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4918 Minor refactoring of SPSDescriptor

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3788 Provide a zero-admin way of updating the statisitcs of an index

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3790 Investigate if request for update statistics can be skipped for certain kind of indexes, one instance may be unique indexes based on one column.

          • Major - Major loss of function.
          • Closed
          is superceded by

          Task - A task that needs to be done. DERBY-4934 Provide automatic update and creation of index cardinality statistics (istat)

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: