Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: why outer join is faster?
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