[thelist] DB Design question

Aleem B aleem.bawany at utoronto.ca
Mon Sep 15 13:33:48 CDT 2003


>> or, assume if the record exists in this joining table that the breed
>> is active, otherwise it's inactive, in which case you can drop the
>> isactive column entirely.
> 
> dude, i like the way you think
> 
> that's clever
> 
> so basically, you get the active ones by doing a join, and
> the rows that
> don't match are dropped
> 

what about querying for inactive records?

And wouldn't that be more expensive to compute?

aleem

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



More information about the thelist mailing list