Re: SQL Query Question
From: JRStern <JRStern_at_gte.net>
Date: Mon, 14 May 2001 15:26:07 GMT
Message-ID: <3afff9c8.3964831_at_news.gte.net>
Date: Mon, 14 May 2001 15:26:07 GMT
Message-ID: <3afff9c8.3964831_at_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 - 17:26:07 CEST