MySQL Forums
Forum List  »  Optimizer & Parser

Re: Unexpected benchmark results due to query optimizer?
Posted by: Kees van den Broek
Date: September 07, 2005 06:47AM

In my original message, "dip" refers to a dip in a line in the graph, it's actually a "sudden speedup" which is caused by something unknown. I should have rephrased it. I don't think b-tree branching is the cause in this case.

In the meantime, I've read something about the order of indexes. It seems that the order of an index is not to be determined by the user. MySQL is able to figure out the best order by itself. MySQL will also traverse the index in the best order depending on the query. Even backwards when necessary.
That could be the cause, but I'm still not very sure about it.

I've looked into the MySQL source code for a little while, but it's not really self-explanatory to me.

I guess it's more complicated.

Thanks for you help.

Options: ReplyQuote

Written By
Re: Unexpected benchmark results due to query optimizer?
September 07, 2005 06:47AM

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.