db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [jira] Commented: (DERBY-855) Document optimizer overrides which were introduced in 10.2
Date Thu, 09 Feb 2006 19:01:51 GMT
Jira is down, so sending an email. Ignore the ; I put at the end of the
example.

On 2/9/06, Mamta A. Satoor (JIRA) <derby-dev@db.apache.org> wrote:
>
>    [
> http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365767]
>
> Mamta A. Satoor commented on DERBY-855:
> ---------------------------------------
>
> Eric, how about rather than "less-than-optimal results", we say
> "less-than-optimal performance"? The results word many be mistaken with the
> query result. If you/anyone else has better wording, please suggest. Also,
> in order to have our example match what we recommend, for joinStrategy
> example, we should use joinOrder in it. As shown below
> SELECT * FROM --DERBY-PROPERTIES joinOrder=FIXED
> t1 a, t1 b --DERBY-PROPERTIES joinStrategy=nestedloop
> WHERE a.c1=b.c1 ;
>
> > 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,
> ctunoptimzoverride.html, derby855-2.diff, derby855.diff,
> derby855_html_files.zip, tuning_guide.zip
> >
> > 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
>
>

Mime
View raw message