I'm suprised by your result too. Did you have an index on the join column? If not that might explain it. One place you might turn to learn more about how mysql optimizes joins is internals.texi. This file describes a lot of the internal workings of mysql and is found in the bk doctree and is also distributed in recent source distributions of mysql. I know its in the 5.0 source (in /Docs), but I don't think its in 4.1.1.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
