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

        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: