Re: No foreign keys??? What the???

In article <962230771.5013.2.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> absent. Enforcing R.I by implementing constraints according to our
 recent
> measurements is 8 times faster compared to an implementation with
 triggers.
> If he doesn't want to go to classes, just fire him, or prepare for
 lawsuits
> if the sw is going to be sold.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>

Why so harsh? In fact, he's not comparing constraints with triggers, which are slow of course. He's comparing foreign key constraints with application code that does the integrity check. Oracle Concepts manual says RI does have a performance hit, but at most just as much as your application code suffers if it takes that responsibility instead.

For absolute performance reason, sure you can disable RI, as long as you're absolutely sure about no tampering with the data directly. Look at how SAP does its work. No RI.

Oracle DBAs don't normally do that. I don't either. Simply because that little performance increase is too risky and is not worth it.

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)


Sent via Deja.com http://www.deja.com/
Before you buy.