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

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Query Question

Re: SQL Query Question

From: JRStern <JRStern_at_gte.net>
Date: Mon, 14 May 2001 15:26:07 GMT
Message-ID: <3afff9c8.3964831@news.gte.net> 






On 14 May 2001 10:00:39 +0100, Philip Lijnzaad <lijnzaad_at_ebi.ac.uk>
wrote:


>And the join takes O(R+S), R

>the number of result rows, S the number of the smallest table.




That's what I'm not clear on, I think you're doing a cartesian product
internally, possibly several in your one-table version, I don't think
anybody's optimizer is going to be smart enough to avoid.



J.
Received on Mon May 14 2001 - 10:26:07 CDT












Original text of this message













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