Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: efficiency NOT NULL vs. Check Constraint

Re: efficiency NOT NULL vs. Check Constraint

From: Dale Edgar <dale_at_databee.com>
Date: Tue, 25 Sep 2001 14:18:42 GMT
Message-ID: <3bb09117.24114306@news.btclick.com>


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



DataBee - Oracle DataBase Subsets
Create small training and development databases the easy way. http://www.databee.com Received on Tue Sep 25 2001 - 09:18:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US