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]

Reply via email to