View Single Post
Old 07-19-2011, 06:01 AM  
raymor
Confirmed User
 
Join Date: Oct 2002
Posts: 3,745
Subqueries are almost always more expensive than the same query expressed as a join. This is because the optimizer is wreak with subqueries and that is being worked on.
__________________
For historical display only. This information is not current:
support@bettercgi.com ICQ 7208627
Strongbox - The next generation in site security
Throttlebox - The next generation in bandwidth control
Clonebox - Backup and disaster recovery on steroids
raymor is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote