[
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 this:
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: 10.2.0.0
> Reporter: Mamta A. Satoor
> Assignee: Eric Radzinski
> Fix For: 10.2.0.0
> 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 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
