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

Tuning manual needs performance tip on compressing tables

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.3.1.4
    • 10.6.1.0
    • Documentation
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bryanpendleton Bryan Pendleton
            chaase3 Camilla Haase
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment