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

Tuning manual needs performance tip on compressing tables

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: