Derby
  1. Derby
  2. DERBY-4121

Documentation: more UPDATE_STATISTICS fixes needed for Reference Manual and Tuning Derby

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.1.1, 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      Kathey Marsden comments on DERBY-3787:

      Not a show stopper for the release, but in beginning my buddy testing,
      I noticed the examples should use CALL e.g.
      CALL SYSCS_UTIL.SYSCS_UPDATE_STATISTICS('SAMP','EMPLOYEE','PAY_DESC');
      CALL SYSCS_UTIL.SYSCS_UPDATE_STATISTICS('SAMP', 'EMPLOYEE', null);

      Also in the Tuning Guide under Working with Cardinality Statistics -> When Cardinality Statistics Go Stale we should refer users to the SYSCS_UTIL.SYSCS_UPDATE_STATISTICS stored procedure to update their statistics and cross reference the reference guide.

      Myrna van Lunteren suggests a new issue for this, so I'm filing it.

      1. DERBY-4121.diff
        3 kB
        Kim Haase
      2. DERBY-4121.stat
        0.1 kB
        Kim Haase
      3. DERBY-4121.zip
        4 kB
        Kim Haase
      4. DERBY-4121-2.diff
        4 kB
        Kim Haase
      5. DERBY-4121-2.zip
        4 kB
        Kim Haase

        Issue Links

          Activity

          Kim Haase created issue -
          Kim Haase made changes -
          Field Original Value New Value
          Link This issue depends on DERBY-3787 [ DERBY-3787 ]
          Kim Haase made changes -
          Attachment DERBY-4121.diff [ 12404985 ]
          Attachment DERBY-4121.stat [ 12404986 ]
          Attachment DERBY-4121.zip [ 12404987 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Kim Haase made changes -
          Derby Info [Patch Available]
          Kim Haase made changes -
          Attachment DERBY-4121-2.diff [ 12405070 ]
          Attachment DERBY-4121-2.zip [ 12405071 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Patch Available]
          Fix Version/s 10.5.1.1 [ 12313771 ]
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.5.1.1 [ 12313771 ]
          Affects Version/s 10.5.0.0 [ 12313010 ]
          Gavin made changes -
          Link This issue depends on DERBY-3787 [ DERBY-3787 ]
          Gavin made changes -
          Link This issue depends upon DERBY-3787 [ DERBY-3787 ]
          Gavin made changes -
          Workflow jira [ 12457393 ] Default workflow, editable Closed status [ 12802380 ]

            People

            • Assignee:
              Kim Haase
              Reporter:
              Kim Haase
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development