[thelist] DB Design question

Aleem B aleem.bawany at utoronto.ca
Tue Sep 16 00:48:26 CDT 2003

>> what about querying for inactive records?
> select a.id
> from a
> left outer
> join b
> on a.id = b.id
> where b.id is null
>> And wouldn't that be more expensive to compute?
> no, not really, no more so than your typical outer join


<tip author="Aleem Bawany" type="Microsoft Outlook">
SpamBayes is an excellent bayesian filter for Microsot
Outlook - probably one of the best ones out there as
of this writing. If you are looking to get rid of SPAM
you must give it a try:


Along the same lines, another invaluable tool for Microsoft
Outlook for more intelligent quotes ( > ):




[ http://www.aleembawany.com/ ]

More information about the thelist mailing list