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 big tables vs. many smaller

Re: one big tables vs. many smaller

From: Alan <alanshein_at_erols.com>
Date: Fri, 5 Apr 2002 14:47:34 -0500
Message-ID: <a8kuqs$slpsr$1@ID-114862.news.dfncis.de>


Perhaps I read the post incorrectly, but I had the impression that there was a 1:1 relationship between his two tables, not a 1:M relationship, in which case he should (usually) combine the tables. The problem, if there is one, is not where I learned relational theory so much as where I learned to read. Anyway, it's not really necessary to insult people, is it?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:542paucqakp8jvrh6uhfqs9llhss2ar87q_at_4ax.com...
> On Thu, 4 Apr 2002 09:49:02 -0500, "Alan" <alanshein_at_erols.com> wrote:
>
> >If the two tables are always or almost always used in combination, then
it
> >makes sense (and from a realtional theory point of view as well) to
combine
> >into one big one. In fact, if, from a realtional theory viewpoint they
> >should be combined, then definitely do so (in this case).
> >
> Question : where, if at all, did you learn relational theory? Did you
> ever even hear of normalization? If so, why do you post this bogus?
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Apr 05 2002 - 13:47:34 CST

Original text of this message

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