Hi Roger, That was just I need. The order isn’t like you say: +----+-------------+-----------+--------+---------------+---------+--------- +--------------------------------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------+--------+---------------+---------+--------- +--------------------------------+-------+---------------------------------+ | 1 | SIMPLE | t1 | const | PRIMARY,uniq | uniq | 250 | const | 1 | Using temporary; Using filesort | | 1 | SIMPLE | t2 | const | PRIMARY,uniq | uniq | 250 | const | 1 | | | 1 | SIMPLE | productos | ALL | PRIMARY,dupli | [NULL] | [NULL] | [NULL] | 16153 | | | 1 | SIMPLE | i2 | eq_ref | PRIMARY,uniq | PRIMARY | 16 | unitel.productos.PROD_ID,const | 1 | Using where | | 1 | SIMPLE | i1 | eq_ref | PRIMARY,uniq | PRIMARY | 16 | unitel.productos.PROD_ID,const | 1 | Using where | +----+-------------+-----------+--------+---------------+---------+--------- +--------------------------------+-------+---------------------------------+
Productos is executed in the middle of the other two ones, the time of the query is about 0.44s - 0.75s, it's a little slow, so if we can optimize a little more should be perfect. Thanks another time, your help is very good for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
