[DERBY-2483] Reduce compilation time for queries with large IN lists made up of literals.

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.3.1.4
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Bug behavior facts: Performance
• Assignee: Unassigned
• Reporter: A B
• Created: 23/Mar/07 17:57
• Updated: 02/Oct/12 05:21

Description

Pulled from the write-up for DERBY-47:

As seen in the beforeAndAfter.html document attached to DERBY-47, the compilation/optimization time for a query with an IN list consisting of all literals is far larger than it is for a similar query in which the IN list consists of all parameters. Since the "probe predicate" optimization implemented as part of DERBY-47 should apply similarly to both types of queries, it would be good to figure out what it is about literals that makes for such a long compilation time (with respect to parameters), and to address that issue.

Note that this relatively excessive compilation time was an issue even before the changes for DERBY-47 were committed.