MyQuoting [EMAIL PROTECTED]: > 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.
My join column was indexed in both tables. I am currently running 4.0.13, however I cant locate the file internals.texi (I assume I'll probably need to download the source package to find it...). I will look for that, thanks for the tip. By the way, if you are using 5.0, do you think it's safe enough in Alpha to try in a production environment ? I like some of its added features over the 4.0 series... > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]