MySQL Forums
Forum List  »  Performance

Re: No keys used tho fields have keys: why?
Posted by: Harrison Fisk
Date: March 06, 2005 06:38PM

Hi,

Can you post the output of an EXPLAIN on the query in question, along with the table definitions (output of SHOW CREATE TABLE). It is hard to understand what is going on with just your word definition and would be much easier to know and answer if you gave us the real output.

Thanks!

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: No keys used tho fields have keys: why?
1830
March 06, 2005 06:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.