Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: one big tables vs. many smaller
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
![]() |
![]() |