Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by JamesSynge:
http://wiki.apache.org/db-derby/DerbyBug47

------------------------------------------------------------------------------
  "Query optimizer should not make poor choices when optimizing IN and WHERE clauses",
  focuses on the same issue.
  
- I attached a program to Derby Bug 47, Derby47PerformanceTest.java, that evaluates
+ I attached a program to Derby Bug 47, {{{Derby47PerformanceTest.java}}}, that evaluates
  a number of different SELECT statements that achieve the same result as evaluating:
  
  {{{ SELECT * FROM someTable WHERE aNonUniqueColumn IN (?, ?, ..., ?) }}}
@@ -31, +31 @@

  Attached to this page are two optimizer traces:
  
  {{{literals-10-trace.txt}}} for 10 parameters using the Literals strategy.
+ 
  {{{markers-10-trace.txt}}} for 10 parameters using the Markers strategy.
  
  What is most interesting is how the cost estimate for Markers is so wrong