Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: One table or many - need valid reasons.

Re: One table or many - need valid reasons.

From: <pobox002_at_bebub.com>
Date: 7 Feb 2005 16:57:08 -0800
Message-ID: <1107824228.064677.306180@f14g2000cwb.googlegroups.com>


David Aldridge wrote:
> One issue that I see is that the advantages that you list for option
2
> apply even more so to the option that you first eliminated -- adding
> new columns to the existing tables. I have a feeling that both of the
> two options you offer have sacrificed performance, integrity, ease of
> understanding, and ease of maintenance in favour of reducing the
> transient workload required in order to integrate a new backend
system.

I agree with everything David says. If you have any doubts about the advice he is offering see if you can make it to the end of this thread.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:10678084117056

-- 
MJB
Received on Mon Feb 07 2005 - 18:57:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US