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: why outer join is faster?

Re: why outer join is faster?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Jun 2005 09:57:12 -0700
Message-ID: <1118249832.383340.273490@z14g2000cwz.googlegroups.com>


web_poste, run an explain plan on both versions of the query. This should show you how Oracle is solving each query and allow you to determine why you are getting the results you are getting.

You should always include the Oracle version number and platform on all posts. You never know when this may be important.

HTH -- Mark D Powell -- Received on Wed Jun 08 2005 - 11:57:12 CDT

Original text of this message

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