Re: How hints affect the CBO?

Yes

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Niall Litchfield wrote in message
<3d221730$0$8513$cc9e4d1f_at_news.dial.pipex.com>...


>Jonathan wrote

>> I have seen Oracle do a nested loop

>> Cartesian join because it has PK or UK information

>> about the first table and knows that the fts will scan

>> only once.

>

>UK = Unique constraint?

>

>

>--

>Niall Litchfield

>Oracle DBA

>Audit Commission UK

>

>