[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364265 ]
Eric Radzinski commented on DERBY-855:
--------------------------------------
Regarding your first point, do you suggest to remove the description about the
default optimizer behaviour, and just include something like this:
constraint
Use the constraint property to override the index that the optimizer selects
and force the use of a particular index or force a table scan.
To force the use of the index that enforces a primary key or unique constraint,
use the constraint property and specify the
unqualified name of the constraint.
And regarding your second point, would updating the syntax at the top of the
topic resolve this issue:
The syntax for FROM clause properties is:
FROM [ -- DERBY-PROPERTIES joinOrder = FIXED | UNFIXED ]
TableExpression [,TableExpression]*
The syntax for table optimizer override properties, which must be included at
the end of a TableExpression, is:
{TableName | ViewName }
[ [ AS ] CorrelationName
[ (SimpleColumnName [ , SimpleColumnName]* ) ] ]
[ -- DERBY-PROPERTIES constraint=<constraint-name> |
index=<index-name> | joinStrategy = NESTED LOOP | HASH ]
> Document optimizer overrides which were introduced in 10.2
> ----------------------------------------------------------
>
> Key: DERBY-855
> URL: http://issues.apache.org/jira/browse/DERBY-855
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.2.0.0
> Reporter: Mamta A. Satoor
> Assignee: Eric Radzinski
> Fix For: 10.2.0.0
> Attachments: ctundepthoptover.html, ctunoptimzoverride.html
>
> Optimizer overrides support in Derby was added as jira entry DERBY-573. Eric
> Radzinski is working on the documentation part of the feature. This issue is
> to keep track of documentation changes.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
