Re: Not null and check constraints

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 07 Jan 2002 00:05:02 +0000
Message-ID: <3C38E62E.EDF895F0@exesolutions.com>

The affect on performance will be negligible. Check constraints are not slowed down by the amount of data in a table or their location. At least not to a degree I have ever been able to measure.

Daniel A. Morgan

Daud wrote:

> Hi
>
> Will there be performance problem (during insert, update etc.) if I
> have many not null and check constraints in a table? What if the table
> has millions of records in it? What's the impact of having those
> constraints? And will there also be performance problem if I do not
> group the 'not null' and null columns?
>
> rgds
> Daud11
Received on Sun Jan 06 2002 - 18:05:02 CST