Re: Hints

From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 18 Aug 2011 01:01:31 -0700
Message-ID: <CAGXkmivDOXoeUVHm0AGy6puHSQA0LZRvRyPv1S+Hcyp0Hv5aXw_at_mail.gmail.com>

Having FKs allows for table elimination transformations: http://blogs.oracle.com/optimizer/entry/why_are_some_of_the_tables_in_my_query_missing_from_the_plan

2011/8/17 <Laimutis.Nedzinskas_at_seb.lt>:
> As for optimizer and foreign keys then it considers only uniqueness.
> F-keys have no effect on CBO whatsoever. Correct me if I am wrong.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 18 2011 - 03:01:31 CDT