James Holmes wrote: > It is common for best practices docs to advise that we should use a join > in preference to a subquery wherever possible, since the subquery > prevents the DB from creating the execution plan it could with a join. > This is probably quite true most of the time.
It is. But it is getting less important as optimizers get better. > Anyone more intimate with the inner dark secrets of SQL is welcome to > comment. If you are looking for an explanation, show use the real SQL and the EXPLAIN output of the queries. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54