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

Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of DERBY-269

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.5.1.1
    • 10.5.1.1
    • Documentation
    • None

    Description

      DERBY-269 added a new system stored procedure in Derby 10.5 to provide the users a way to update the statistics for all the indexes or one specific index on a table. We should document this in our documentation.

      Attachments

        1. rrefupdatestatsproc.html
          4 kB
          Camilla Haase
        2. DERBY-3787-2.diff
          4 kB
          Camilla Haase
        3. rrefupdatestatsproc.dita
          2 kB
          Laura Stewart
        4. derby3787.diff
          77 kB
          Laura Stewart
        5. rrefupdatestatsproc_2.html
          3 kB
          Laura Stewart
        6. rrefupdatestatsproc.html
          3 kB
          Laura Stewart

        Issue Links

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4121 Documentation: more UPDATE_STATISTICS fixes needed for Reference Manual and Tuning Derby

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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-269 Provide some way to update index cardinality statistics (e.g. reimplement update statistics)

          • Major - Major loss of function.
          • Closed

          Activity

            People

              scotsmatrix Laura Stewart
              mamtas Mamta A. Satoor
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: