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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Outer joins = full scan?

Re: Outer joins = full scan?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 02 Jun 2003 08:32:04 +0000
Message-ID: <bber4f$2d9$2@ctb-nnrp2.saix.net>


Ed Prochak wrote:

> So as another poster pointed out, are those attributes usable for the
> index he wants to use. If they are, a suitable hint might move the CBO to
> go the other way.
>
> Thanks for the sanity check.

Ed, the only way to check for sanity is to see his indexes. :-)

--
Billy
Received on Mon Jun 02 2003 - 03:32:04 CDT

Original text of this message

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