NULL or 0 for a "FLAG_COLUMN"

Hey all.

>From a general ORACLE point of view (lets say 9i2 upwards), what would
be the preferred way of storing a true/false flag column.

1. col MY_FLAG: NOT NULL, DEFAULT 0, Possible values: 1, 0 or
2. col MY_FLAG: Possible values 1, NULL

There is some side effect of having NULL vs. 0 when using indexes, right?
Any other ideas why the one or other might be better (Storage / Performance / Indexing)?

thanks!

best,
Martin Received on Wed Sep 06 2006 - 09:55:38 CDT