[DERBY-4595] Inferior query plan chosen for outer join

• Type: Improvement
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 10.5.3.0
• Component/s: SQL
• Labels: derby_triage10_10 plan query
• Environment: Ubuntu 9.10, Sun Java 6 update 18
• Urgency: Normal
• Bug behavior facts: Performance, Seen in production
• Assignee: Unassigned
• Reporter: Witold Szczerba
• Created: 24/Mar/10 20:06
• Updated: 30/Sep/12 00:10

Description

I was describing everything here and when trying to submit - everything was lost, because the session ended and there was no way of going back, so I will just point to derby-user mailing list, everything is there, just follow the thread:
http://mail-archives.apache.org/mod_mbox/db-derby-user/201003.mbox/[e-mail]%3E
or there:
http://thread.gmane.org/gmane.comp.apache.db.derby.user/12394

The bottom line is - I had to change application to avoid the query, it is so slow (around one hour on production) and there is no workaround.