Re: database design question

The primary key/foreign key buys you speed. Plus you are explicitly specifying the relationship, which becomes a form of documentation on the intended correct usage. For a small project this doesn't seem like much of a reason, but next time you're working on a 200+ table schema with no ER diagram (where relationships would have been explicitly shown), you'll swear prolifically at the lack of such things. -djc

> The question is: would you set up a primary-foriegn key relationship or
> should I just load each file into a table in Oracle and just do joins
> when I need to get infomation out of the database. What would having
> the primary-foreign key relationship buy me.
Received on Tue Oct 28 1997 - 00:00:00 CST