On Tue, Mar 2, 2010 at 12:33 PM, praveen kumar <praveenkum...@gmail.com> wrote: >> >> >> 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) >
Thanks praveen _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc