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.

    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_3.diff
          11 kB
          Laura Stewart
        2. rtuntransform582.html
          10 kB
          Laura Stewart
        3. rtuntransform582.html
          10 kB
          Laura Stewart
        4. derby2499_2.diff
          11 kB
          Laura Stewart
        5. rtuntransform582.html
          10 kB
          Laura Stewart
        6. derby2499_1.diff
          9 kB
          Laura Stewart

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: