db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-4595) Inferior query plan chosen for outer join
Date Tue, 06 Sep 2011 17:43:13 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Myrna van Lunteren updated DERBY-4595:

    Priority: Critical  (was: Blocker)

Lowering priority from blocker to critical; it certainly warrants investigation but not enough
to block a release.

> Inferior query plan chosen for outer join
> -----------------------------------------
>                 Key: DERBY-4595
>                 URL: https://issues.apache.org/jira/browse/DERBY-4595
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>         Environment: Ubuntu 9.10, Sun Java 6 update 18
>            Reporter: Witold Szczerba
>            Priority: Critical
>              Labels: plan, query
>         Attachments: netbroker-ddl.txt, queryplan-1.txt, queryplan-1b.txt, queryplan-2.txt,
> 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/%3Ce0a08d801003190619l3d3181pa55ca79145b7810d@mail.gmail.com%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.

This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message