Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-47 Some possible improvements to IN optimization
  3. DERBY-2499

Update Tuning Guide documentation to reflect the new static IN list transformation that occurs as a result of DERBY-47.

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.3.1.4
    • 10.3.1.4
    • Documentation
    • None

    Description

      DERBY-47 changed the static rewrite logic for IN lists. Whereas we used to create a BETWEEN predicate for IN-lists that contain all constants and then use that predicate to limit the scan, we now create a "probe predicate" for IN-lists that contain all constants and/or parameter nodes and then use that new predicate to perform execution-time probing.

      The documentation in the Tuning Guide needs to be updated to reflect this change in behavior.

      Attachments

        1. derby2499_1.diff
          9 kB
          Laura Stewart
        2. derby2499_2.diff
          11 kB
          Laura Stewart
        3. derby2499_3.diff
          11 kB
          Laura Stewart
        4. rtuntransform582.html
          10 kB
          Laura Stewart
        5. rtuntransform582.html
          10 kB
          Laura Stewart
        6. rtuntransform582.html
          10 kB
          Laura Stewart

        Activity

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

          People

            scotsmatrix Laura Stewart
            army A B
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment