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: Query performance: DivideAndConquer vs. BruteForce

Re: Query performance: DivideAndConquer vs. BruteForce

From: David Williams <djw_at_smooth1.fsnet.co.uk>
Date: Tue, 8 Jan 2002 22:10:37 -0000
Message-ID: <a1fqp2$hj4$1@news8.svr.pol.co.uk> 






"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3c3ae18b.3166895_at_news-vip.optusnet.com.au...


> Jim Kennedy doodled thusly:

>

> >I haven't had this problem under Oracle. (joins greater than 3 tables)

>

> me neither.  this morning did an 11 table join without the slightest

> performance problem...

>

>




  With complex subqueries, where exists and where not in's
   with outer joins?



> Cheers

> Nuno Souto

> nsouto_at_optushome.com.au.nospam

Received on Tue Jan 08 2002 - 16:10:37 CST












Original text of this message













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