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

The Tuning guide should mention that LIKE transformations/optimizations are disabled when using territory-based collations

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.3.0, 10.4.1.3, 10.5.1.1
    • Fix Version/s: 10.5.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      The Tuning Guide section titled "LIKE transformations" describes transformations and optimizations which Derby performs on LIKE expressions in order to avoid full table scans. These transformations/optimizations are disabled when using territory-based collations. See DERBY-3854. The Tuning Guide does not mention this fact but it is likely that this information would be very useful to customers and tech support engineers. The "LIKE transformations" section in the Tuning Guide should be changed to mention that LIKE transformations/optimizations are disabled when using territory-based collations.

        Attachments

        1. DERBY-3855.diff
          0.7 kB
          Camilla Haase
        2. rtuntransform208.html
          4 kB
          Camilla Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: