[
https://issues.apache.org/jira/browse/DERBY-4818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-4818:
---------------------------------
Summary: Derby is taking a long time to compile SQLs with more than 9
tables for the first time. (was: Derby is taking a long time to parse SQLs
with more than 9 tables for the first time.)
Issue Type: Improvement (was: Bug)
I slightly modified the title here (parse->compile) and changed from bug to
improvement request, according to Derby's classification scheme.
> Derby is taking a long time to compile SQLs with more than 9 tables for the
> first time.
> ---------------------------------------------------------------------------------------
>
> Key: DERBY-4818
> URL: https://issues.apache.org/jira/browse/DERBY-4818
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.4.1.3
> Environment: All OS platforms and all JVM versions on Derby 10.4.1.3
> Reporter: Trung Tran
>
> I have SQLs with 9 or more tables and it takes a couple of minutes to compile
> these SQLs for the first time. I'm assuming that the optimizer is taking a
> long time to figure out the query plan.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
