Hi Roger, You are ok, there was an index problem in one table, they name of the rows wasn't equal and MySQL didn't recognize they as the same index. I have changed the row name and now is working fine, but I have a little question, How can I use indexes with different names in it's tables?
Thanks for your help, you have been very helpful for me. Roberto -----Mensaje original----- De: Roger Baklund [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 20 de abril de 2005 18:30 Para: mysql@lists.mysql.com CC: Dto. Sistemas de Unitel Asunto: Re: Query Problem Dto. Sistemas de Unitel wrote: > 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. It seems as there is no index on productos.prod_id? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
