1. Derby
  2. DERBY-4327

Implement optimizer support for bushy trees.


    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
    • Bug behavior facts:
      Performance, Seen in production


      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:

        Issue Links


          Ramin Baradari made changes -
          Comment [ Sehr geehrte Damen und Herren,

          vielen Dank für Ihre Nachricht. Ich bin ab 1. Oktober 2012 wieder im Haus. Meine E-Mails werden nicht weitergeleitet und erst dann beantwortet. In dringenden Fällen wenden Sie sich bitte an Robert Buchwald unter der E-Mail-Adresse

          Mit freundlichen Grüßen
          Ramin Baradari

          Dear Sir or Madam:

          Thank you very much for your email. I will be out of the office until October 1, 2012. I will answer your email upon my return. Please note that your email will not be forwarded during this time. In urgent cases, please do not hesitate to contact Robert Buchwald,

          Best regards
          Ramin Baradari
          Gavin made changes -
          Workflow jira [ 12471826 ] Default workflow, editable Closed status [ 12797158 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_10
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-1907 [ DERBY-1907 ]
          Rick Hillegas created issue -


            • Assignee:
              Rick Hillegas
            • Votes:
              2 Vote for this issue
              2 Start watching this issue


              • Created: