Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How hints affect the CBO?

Re: How hints affect the CBO?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 2 Jul 2002 22:12:16 +0100
Message-ID: <3d221730$0$8513$cc9e4d1f@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


Received on Tue Jul 02 2002 - 16:12:16 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US