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 row
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