db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4595) Inferior query plan chosen for outer join
Date Mon, 13 Sep 2010 23:30:32 GMT

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

Dag H. Wanvik updated DERBY-4595:

            Issue Type: Improvement  (was: Bug)
    Bug behavior facts: [Performance, Seen in production]  (was: [Performance])

> 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: Blocker
>         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.
You can reply to this email to add a comment to the issue online.

View raw message