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: andrewst <member14183_at_dbforums.com>
Date: Fri, 30 May 2003 12:49:29 +0000
Message-ID: <2939989.1054298969@dbforums.com> 






Originally posted by andrewst 


> Hard to answer without knowing what indexes you have.  Suppose the

> only index on T was (debtor_id,...).  That could be used for the

> second query (if driving from C) but not for the first.

> 



Sorry, that was b*ll*cks since you have c.debtor_id IS NULL
Ignore that!


--
Posted via http://dbforums.com


Received on Fri May 30 2003 - 07:49:29 CDT












Original text of this message













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