MySQL Forums
Forum List  »  Optimizer & Parser

Re: Close to a million records & query too slow
Posted by: sabelo simelane
Date: March 08, 2010 03:36PM

Rick, you're a genius man! This query was running for 1 min 0.76 sec and now it runs for only 0.04 sec. It's unbelievable what my ignorance was costing me!

Again, thank you Rick, I do appreciate your assistance.

--
Sabelo

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Close to a million records & query too slow
2273
March 08, 2010 03:36PM


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.