db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mi...@apache.org
Subject svn propchange: r783168 - svn:log
Date Wed, 05 Aug 2009 17:08:07 GMT
Author: mikem
Revision: 783168
Modified property: svn:log

Modified: svn:log at Wed Aug  5 17:08:07 2009
--- svn:log (original)
+++ svn:log Wed Aug  5 17:08:07 2009
@@ -1,3 +1,5 @@
 Following is the patch description for DERBY-3926. 
 The problem with the trunk codeline is that when optimizer goes through optimizables in a
join order, it only looks at those optimizables individually to decide whether sorting can
be avoided on them or not. That approach leaves out few queries which require sorting but
do not get sorted. The decision for avoiding sorting should also include relationship between
the optimizables in a given join order. Following query demonstrates the trunk problem 
 SELECT table1.id, table2.value, table3.value FROM --DERBY-PROPERTIES joinOrder=FIXED 

View raw message