Re: RELY option in constraint.

Rely communicates to the optimizer that the data in the table follows the constraint's rule and permits it to use the rule in developing its access path to the data.

It allows you enforce constraints the old fashioned way (on your own) and communicate that you have done so to the optimizer.

Of course you can lie. It's your performance. ----- Original Message -----
From: Johnson Poovathummoottil <joni_65_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 01, 2000 8:47 AM Subject: RELY option in constraint.

> Hi,
>
> What does the rely option do for a constraint?
>
> If I have an FK as disable novalidate. So that query
> rewrite can take place. I wonder what rely can do in
> addition to this? All what I want is the data
> dictionary to contain info about the contraint. so
> that querys can use it. If disable novalidate already
> does it, What is the need of rely option.?
>
>
> Johnson
>
>
> __________________________________________________
> Do You Yahoo!?
> >From homework help to love advice, Yahoo! Experts has your answer.
> http://experts.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Johnson Poovathummoottil
> INET: joni_65_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Nov 01 2000 - 11:30:44 CST