I don't know how most DBMS systems behave, but MaxDB 7.5 Explain shows that
the following SQL statement generates a ton of I/O:
SELECT *
FROM TableA, TableB, TableC
WHERE TableA.A1 (+) = TableB.B1
AND TableA.A2 (+) = TableC.C1
AND 1=2
It seems to do the I/O for the joins, despite the "1=2" clause. I have not
tested this using "LEFT JOIN" syntax.
Just wanted to pass this along in case it was any use. I do not consider
this an important case, just one I ran into in testing some code.
Stephen Gutknecht
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
