Derby
  1. Derby
  2. DERBY-3259

Tuning manual needs performance tip on compressing tables

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)

      For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.

      1. docs.diff
        6 kB
        Bryan Pendleton
      2. docs.diff
        6 kB
        Bryan Pendleton
      3. ctunstats849505.html
        4 kB
        Bryan Pendleton
      4. ctunstats849505.html
        4 kB
        Bryan Pendleton
      5. ctunperfstatistics.html
        5 kB
        Bryan Pendleton
      6. ctunperfstatistics.html
        6 kB
        Bryan Pendleton
      7. ctunperf25864.html
        7 kB
        Bryan Pendleton

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development