Uncorrelated subqueries

Article:		How to Misuse SQL's FROM Clause
Subject:		Uncorrelated subqueries
Date:		2004-11-05 10:36:35
From:		runrig

I've seen examples where it sped up the query when you used 'distinct' (or a 'group by' clause) in the uncorrelated subquery.