Re: What is the cost of integrity constraints?

From: gym dot scuba dot kennedy at gmail <>
Date: Wed, 15 Apr 2009 14:04:03 GMT
Message-ID: <nPlFl.231$>

"yossarian" <> wrote in message news:49e5dff6$0$700$
> 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

Original text of this message