Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: efficiency NOT NULL vs. Check Constraint
Hi Tim
On 25 Sep 2001 06:33:25 -0700, papakee_at_aol.com (Tim McKee) wrote:
>What is more efficient having a not null constraint on a field or
>including a NVL check in a check constraint?
I ran some tests on this sort of thing a couple of years ago on a 7.3 database and the NOT NULL was more efficient then.
Regards
Dale