MySQL Forums
Forum List  »  Optimizer & Parser

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

Hi,

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
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3008
October 15, 2004 12:35PM
Re: Query Optimizer Problems
2450
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.