Re: RI - pros and cons

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 21 Mar 2002 21:32:07 -0600
Message-ID: <ug02taz42.fsf@rcn.com>

On Thu, 21 Mar 2002, spamdump_at_nospam.noway.nohow wrote:

> Which is exactly my postion. But the other DBA keeps claiming that RI
> is "more trouble than it is worth" and that his position is backed up
> by "many other DBA's"

I doubt this highly. Have him point you to specific DBA's thoughts saying this.

> He won't give any specifics about the downside to RI,

There are performance hits. The database has to check the parent tables to see that the keys exist.

> so I thought I'd ask here if anyone knows of any downsides. I think
> he's just blowing smoke

No, he's smoking something. I'd only agree with him beside a campfire as we all passed around a big spleef.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Thu Mar 21 2002 - 21:32:07 CST