OK, this will be my last post on this topic. Mainly I want to point out that I was taking the wrong conclusions from the results of my tests. I followed the advice of Michael Stassen and ran some more tests using int columns for joins and got pretty much the same trend. So I guess the real answer is that joins between static tables are faster than joins between dynamic tables (by about 20% for the int column join). I guess this is what the MySQL manual is talking about (and other people who posted the same thing to this thread).
Matt Fagan [EMAIL PROTECTED] http://greetings.yahoo.com.au - Yahoo! Greetings Send your love online with Yahoo! Greetings - FREE! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
