[Ilugc] mysql query optimization
- From: praveenkumaar@xxxxxxxxx (praveen kumar)
- Date: Tue Mar 2 12:34:29 2010
Thanks for explaining. Isn't a join supposed to be always better than
IN+subquery?
________________
if the inner query results are less then sub query will outperform the join
query (especially when using IN)
--
Praveen kumar p
+91 9884410904
Other related posts: