On Oct 05, 2006, at 11:44 AM, Guyren Howe wrote:
This solution will be fastest in many SQL dialects (don't know
about sqlite):
select p.* from tpersons as p left outer join tHats as h on
(p.idNumber = h.ownerIDNumber ) where h.ownerIDNumber = nil
I know of at least two where the one I posted will be fastest.
It's all engine dependent and how they resolve certain kinds of queries.
Some resolve subqueries very fast and left outer joins slower.
Testing for specific results is always a good idea.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
