MySQL Forums
Forum List  »  Optimizer & Parser

Re: select distinct slower in 5.0 than 4.1
Posted by: Jay Pipes
Date: December 20, 2005 11:36AM

Hmmm. Very interesting. Well, this is definitely the type of query that a *tight* index scan might be used (see, and from the docs, I can't tell whether MySQL would indicate in the Extra column if it has chosen to do this. But, from what you're describing, it certainly sounds like the query optimizer has been tweaked to prefer this type of optimization, and in your case, it is negatively affecting the outcome.

Why don't we do this. Can you work on getting a mysqldump of your DB (if that's possible) and I'll try to contact someone who might be able to take a closer look at this? I'll have them post back here with advice on what to do next. (I'm thinking Edwin DeSouza...)

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster?

Options: ReplyQuote

Written By
December 18, 2005 12:24PM
December 19, 2005 10:49AM
Re: select distinct slower in 5.0 than 4.1
December 20, 2005 11:36AM

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.