MySQL Forums
Forum List  »  Stored Procedures

Re: alternate of temporary table?
Posted by: Aamir Sohail
Date: March 31, 2014 02:18AM

Thank you for optimization tips. I have done some changes and its good now.
> IN ( SELECT ... )

> optimizes poorly. Change it to a JOIN if possible.

now optimized using join.

> ( SELECT COUNT(*) ... ) + ( SELECT COUNT(*) ... )

this are from different table.

And I am looking into another points.

Now back to the temporary table problem. How I can get alternative?

Options: ReplyQuote

Written By
March 28, 2014 06:07AM
March 30, 2014 10:45PM
Re: alternate of temporary table?
March 31, 2014 02:18AM

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.