On 11.04.2007 21:38 CE(S)T, Igor Tandetnik wrote:
> No. The other table affects the result of the query, so the join still
> has to be performed.
I see. I haven't thought of that effect. Thank you for the reply.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http:/
Yves Goergen <[EMAIL PROTECTED]>
wrote:
I was thinking about what happens when I do an SQL query that names
tables and joins between them that aren't used at all. For example
this:
SELECT m.Sender, m.Subject FROM Message m, MessageTag mt;
Full cartesian product, aka cross-product. For every ro
2 matches
Mail list logo