db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Radzinski (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-855) Document optimizer overrides which were introduced in 10.2
Date Wed, 01 Feb 2006 18:38:06 GMT
    [ http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364849 ] 

Eric Radzinski commented on DERBY-855:

There's three open issues on derby-855.  I've summarized them here:

--- Does this text adequately address your concern about the description of the constraint

To force the use of the index that enforces a primary key, a foreign key, or unique constraint,
use the constraint property and specify the 
unqualified name of the constraint.  The constraint property can be used only within a TableExpression,
and it
can be specified only on base tables; it cannot be specified on views or derived tables.

--- I haven't seen a response about my proposal to modify the syntax to include the properties
in the syntax.  Here's what I proposed on 1/27:

The syntax for FROM clause properties is: 
         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 = NESTEDLOOP | HASH ] 

--- Regarding the comment about runstats output, is there a doc to-do in this comment?  or
does this apply only to the output when a foreign key is specified? If there is a doc to-do,
can you provide me some details about what it should include?

> 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:
>     Reporter: Mamta A. Satoor
>     Assignee: Eric Radzinski
>      Fix For:
>  Attachments: ctundepthoptover.html, ctunoptimzoverride.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

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message