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]
