I would recommend you use a default value (which I guess should be 0 in this case) instead of allowing NULL. The existing data can be updated to the default value manually. This will help to get rid of the
OR in the
WHERE clause which usually is a performance killer.
commented on Aug 15 2012 5:57AM