db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-855) Document optimizer overrides which were introduced in 10.2
Date Tue, 31 Jan 2006 21:30:34 GMT
    [ http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364723 ] 

Satheesh Bandaram commented on DERBY-855:

I think the contraint override can be used for foreign key constraints as well... I tried

 create table prim ( i int not null primary key, j int);
 create table sec (i int, constraint fk foreign key(i) references prim(i), j int);

 select * from sec --derby-properties constraint=fk

        optimizer estimated cost:          136.34

        User supplied optimizer overrides on SEC are { index=SQL060131012414010}   <=========
        Index Scan ResultSet for SEC using constraint FK at read committed isolation level
using instantaneous share row locking chosen by the optimizer
        Number of opens = 1

> 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