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

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Documentation
• Assignee: Laura Stewart
• Reporter: A B
• Created: 28/Mar/07 17:19
• Updated: 21/Jan/11 18:13
• Resolved: 25/Apr/07 21:51

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.