db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6765) Further improvements on derby optimizer overrides are possible
Date Tue, 21 Oct 2014 15:28:33 GMT
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

View raw message