Excellent Primer

John8/31/2007 6:02:41 AM

Very informative article. I use what turn out to be non-correlated subqueries quite a lot, and was glad to find they're non-correlated. The certainly run quite fast, though my recorsets are fairly small - only about 20,000 outer and about 2,000 inner.

Concerning the correlated subquery example in your article: although this illustrates your point very nicely, why not use a non-correlated subquery instead, along the lines of:

SELECT a.au_id, a.au_lname, a.au_fname
FROM authors a
WHERE a.au_id IN (SELECT t.au_id
FROM titleauthor t)

Adam Fleck 6/29/2004 6:07:19 PM