null values are not indexed btw. (maybe thigs have changed in the last few years but) using a value like 0 as a quasi null means that
select user_id from users where b_sysadmin is null versus select user_id from users where b_sysadmin = 0 do an explain plan in oracle or execution plan in sql server, the second can use an index, the first cannot, which means the db server has to do a full table scan ( slow, expensive ) there are tricks to use a join in oracle to get around this z ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
