Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NULL or 0 for a "FLAG_COLUMN"
Martin T. wrote:
> Hey all.
>
>>From a general ORACLE point of view (lets say 9i2 upwards), what would
On option allows NULL values the other does not. Instead of focusing on performance/storage/indexing, how about focusing on the business rules? Defining a column as NOT NULL is placing a constraint on the data in that column. Does that constraint enforce your company's rules or not? The business rules drive constraints, not the other things you are looking at.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Wed Sep 06 2006 - 10:09:02 CDT
![]() |
![]() |