This is great info, thanks so much guys! On Thu, Feb 17, 2011 at 9:28 AM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote: > Generally I think most who desire this behavior use "rely disable > novalidate" for their FKs. > > http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/constra.htm#i1006284 > > On Thu, Feb 17, 2011 at 12:28 AM, Timur Akhmadeev > <Akhmadeev@xxxxxxxxxxxxxx> wrote: > > But you can make CBO to rely on the constraint even if it is disabled: > > -- > Regards, > Greg Rahn > http://structureddata.org >