Andrew Braithwaite wrote:
Hi,You're doing a join on 'BoardID' on the tables MSGS and MBOARD. Is the BoardID field indexed on the MSGS table too? If not then that may be your problem. Cheers, Andrew
He said, "MSGS ... is indexed on BoardID". Did you look at the EXPLAIN output? The query is using the index on MSGS.BoardID.
Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]