Re: What is the cost of integrity constraints?
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Wed, 15 Apr 2009 14:04:03 GMT
Message-ID: <nPlFl.231$N5.25_at_nwrddc01.gnilink.net>
Date: Wed, 15 Apr 2009 14:04:03 GMT
Message-ID: <nPlFl.231$N5.25_at_nwrddc01.gnilink.net>
"yossarian" <yossarian99_at_operamail.com> wrote in message
news:49e5dff6$0$700$5fc30a8_at_news.tiscali.it...
> Phper wrote:
>
>> Does the database run much slower if there are many integrity
>> constraints?
>
> Of course. Constraints and datatypes are stuff for boring geeks. Real
> DBAs only use varchar2(255) unconstrained nullable columns.
>
> Y.
varchar2(255) is so passe. Most of us modern dbas use 1 table and
varchar2(4000). Why make the design more complicated than necessary? Easy
to find the data it is in the eva table.
Jim
Received on Wed Apr 15 2009 - 09:04:03 CDT