Hi. Everything is OK.
See: http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html http://dev.mysql.com/doc/mysql/en/EXPLAIN.html A Z <[EMAIL PROTECTED]> wrote: > > Hi, > > MySql 4.0.14 > How can I force the following query to use a reference > in table1. > > select * from table1 a left join table2 b on (a.field1 > = b.field1) order by b.field2 limit 1 > > both a.field1 and b.field1 have indexes. Explaining > the command indicates that, MySql uses an index > (possible_keys) on table2 but All on table1. > > Is this how it should be? > > regards > > > Send instant messages to your online friends http://uk.messenger.yahoo.com > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
