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

"David" <begin_at_snssoftware.com> wrote in message news:slkop965jev137_at_corp.supernews.com...
> There is a guy I work with who has designed a database with no foreign
 keys.
> There are about 50 tables. Is this crazy? He sais that it's for
> performance reasons.
>
> All opinions and comments are welcome, no matter how sarcastic or
 insulting
> :)
>
> Cheers!
> Dave
>
>
>
>

Yes, this is crazy! You don't plan to sell this software commercially, do you. One of my previous firms bought standard sw with no relational integrity (RI) and no normalization in it. It was a real nightmare. Also how does he enforce R.I. if at all. If he says he does that for performance reasons, he obviously needs to be sent to an Oracle class asap, as his knowledge is several lacking if not 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 Received on Thu Jun 29 2000 - 00:00:00 CDT