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