MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query Optimizer Problems
Posted by: Harrison Fisk
Date: October 15, 2004 02:11PM


Is that your real query there? I don't think it would choose to use that index, due to the fact it is impossible to use it to resolve your query. You aren't use studentid in the query, yet that is the left most index part, so it would have to use it.

Can you post the full explain for the actual query in question and the table structures? Thanks.

Harrison Fisk, Trainer and Consultant

Options: ReplyQuote

Written By
October 15, 2004 12:35PM
Re: Query Optimizer Problems
October 15, 2004 02:11PM

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.