[
https://issues.apache.org/jira/browse/DERBY-4340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-4340:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_10 (was: )
> Make it possible to do optimizer overrides in bracketed comments
> ----------------------------------------------------------------
>
> Key: DERBY-4340
> URL: https://issues.apache.org/jira/browse/DERBY-4340
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Bernt M. Johnsen
> Labels: derby_triage10_10
>
> Implement optimzier overrides (or --DERBY-PROPERTIES clause) in brackted
> comments.
> Instead of
> SELECT * FROM --DERBY-PROPERTIES joinOrder=FIXED
> t1 a, t1 b --DERBY-PROPERTIES joinStrategy=NESTEDLOOP
> WHERE a.c1=b.c1
> I want to be able to write e.g.:
> SELECT * FROM /*DERBY-PROPERTIES joinOrder=FIXED*/ t1 a, t1 b
> /*DERBY-PROPERTIES joinStrategy=NESTEDLOOP*/ WHERE a.c1=b.c1;
> or
>
> SELECT * FROM /*--DERBY-PROPERTIES joinOrder=FIXED*/ t1 a, t1 b
> /*--DERBY-PROPERTIES joinStrategy=NESTEDLOOP*/ WHERE a.c1=b.c1;
> or something similar.
--
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
