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


Subject
Views
Written By
Posted
2489
March 28, 2014 06:07AM
2533
March 30, 2014 10:45PM
Re: alternate of temporary table?
1104
March 31, 2014 02:18AM
1031
March 31, 2014 09:46AM


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.