MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize Query with multiple joins
Posted by: Angel Lacustre
Date: March 24, 2011 07:02AM

Thanks for the fast answer, glad to know that the query plan is as good as it can be.

Your guess was right, the "" is the alias for "dest". I guess my benchmarking simply wasn't that good, I'll remove the distinct.

Also, I'm aware of the non order by clause. I think it wasn't added in the beggining for performance reasons, I'll add it now.

That said, where could I investigate further the reason of this query being slow under heavy load? Maybe it's a hardware limitation?

Thanks again!


Edited 1 time(s). Last edit at 03/24/2011 07:04AM by Angel Lacustre.

Options: ReplyQuote

Written By
Re: Optimize Query with multiple joins
March 24, 2011 07:02AM

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.