[jira] [Created] (DERBY-6765) Further improvements on derby optimizer overrides are possible

["Myrna van Lunteren (JIRA)" <ji...@apache.org>]

Myrna van Lunteren created DERBY-6765:
-----------------------------------------

             Summary: Further improvements on derby optimizer overrides are possible
                 Key: DERBY-6765
                 URL: https://issues.apache.org/jira/browse/DERBY-6765
             Project: Derby
          Issue Type: Improvement
            Reporter: Myrna van Lunteren


With DERBY-573 support was provided for derby specific optimizer overrides, by using the --DERBY-PROPERTIES phrase in a query.

DERBY-6305 was regarding improvement in documentation.
A number of overrides are still referenced in the code but their workings needs to be researched and possibly improved; tests need to be devised for them; and they need to be documented.

Rick attached a spec to DERBY-6305 that can be used as the starting point for this work: https://issues.apache.org/jira/secure/attachment/12596337/DerbyDashProperties.html.
A wiki page was created to refer to the undocumented properties: https://wiki.apache.org/db-derby/UndocumentedDerbyBehavior
And there was discussion on the developers list resulting in the improved documentation: http://apache-database.10148.n7.nabble.com/is-there-an-optimizer-override-to-force-multi-probe-query-plan-td132838.html



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)