db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Witold Szczerba (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4595) Inferior query plan chosen for outer join
Date Wed, 24 Mar 2010 20:13:27 GMT

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

Witold Szczerba updated DERBY-4595:

    Attachment: queryplan-1b.txt

The database definition and query plans.

> Inferior query plan chosen for outer join
> -----------------------------------------
>                 Key: DERBY-4595
>                 URL: https://issues.apache.org/jira/browse/DERBY-4595
>             Project: Derby
>          Issue Type: Bug
>    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