[jira] Commented: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=comments#action_12357700 ] Kevin Hore commented on DERBY-47: - I have evidence (presented below) that the query optimizer is making some very poor choices when deciding how to make use of the available

[jira] Updated: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=all ] Kevin Hore updated DERBY-47: Attachment: QueryPlanUniqueIndexAndWordIndexOneTerm.txt Query plan for comment made by Kevin Hore 2005/11/15. This is the query plan produced by the optimizer when

[jira] Updated: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=all ] Kevin Hore updated DERBY-47: Attachment: QueryPlanUniqueIndexAndWordIndexTwoTerms.txt Query plan for comment made by Kevin Hore 2005/11/15. This is the query plan produced by the optimizer when

[jira] Updated: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=all ] Kevin Hore updated DERBY-47: Attachment: QueryPlanUniqueIndexOnlyOneTerm.txt Query plan for comment made by Kevin Hore 2005/11/15. This is the query plan produced by the optimizer when matching

[jira] Updated: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=all ] Kevin Hore updated DERBY-47: Attachment: QueryPlanUniqueIndexOnlyTwoTerms.txt Query plan for comment made by Kevin Hore 2005/11/15. This is the query plan produced by the optimizer when matching

[jira] Commented: (DERBY-47) Some possible improvements to IN optimization

[ http://issues.apache.org/jira/browse/DERBY-47?page=comments#action_12357601 ] Kevin Hore commented on DERBY-47: - I have also found this issue to be a problem and would like to know whether there are any plans to fix it? What follows is a copy of