Implement optimizer support for bushy trees.
--------------------------------------------
Key: DERBY-4327
URL: https://issues.apache.org/jira/browse/DERBY-4327
Project: Derby
Issue Type: Improvement
Components: SQL
Reporter: Rick Hillegas
Currently, the optimizer only considers left-deep trees. For queries involving
many tables, the best plan may be bushy. In this email thread, a user notes
poor performance by Derby on queries involving 5 or more tables:
http://www.nabble.com/Slow-performance-on-5-or-more-joins-in-a-star-schema-tt24708686.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
