MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizer - subqueries
Posted by: Jake Day
Date: November 02, 2005 08:50AM

Thanks Felix, I'll give this a try.....

I've actually been forced to "create" a permanent table now to reflect the "subquery". (which takes around 5 seconds to populate)

If its permanent, then it doesn't have to do the subquery first, so the query runs in around 10 seconds.....

this is slightly better than the optimizer deciding that the outer part should be run first and me cancelling it after 30 minutes!!!

cheers though for your help.

Jake

Options: ReplyQuote


Subject
Views
Written By
Posted
4663
November 01, 2005 09:59AM
2556
November 02, 2005 03:52AM
Re: Optimizer - subqueries
2444
November 02, 2005 08:50AM


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.