Mysql 4.0.14 2 Tables:
Table1: Indexed on Field1 (primary key), Field2 Table2: Indexed on Field1 (primary key), Field2 (Foreign key from table1) When I do this explain select a.*, b.* from table1 a, table2 b, where a.field1 = b.field2 and a.field2 = 'value'. returns the result: Table type possible_keys Key Key_len ref a ALL Primary, Field2 b ref Field2 Field2 37 a.Field1 And it takes along time to process (~25 seconds) on only ~5000 records. Is there anything we do wrong here? regards ___________________________________________________________ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]