db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-4595) Inferior query plan chosen for outer join
Date Sun, 30 Sep 2012 00:12:07 GMT

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

Mamta A. Satoor updated DERBY-4595:

    Urgency: Normal
     Labels: derby_triage10_10 plan query  (was: plan query)
> 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: derby_triage10_10, plan, query
>         Attachments: netbroker-ddl.txt, queryplan-1b.txt, queryplan-1.txt, queryplan-2b.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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message