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: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Fri, 5 Apr 2002 11:13:40 +0200
Message-ID: <a8jptr$srbva$1@ID-54600.news.dfncis.de>


"damorgan" <damorgan_at_exesolutions.com> wrote in message news:3CAC87E3.387D6428_at_exesolutions.com...
> Much like other things in life ... size has nothing to do with it ... it
is
> what you do with it that counts. The definition of a table should be based
on
> data normalization tempered by performance. If it belongs in one table ...
> stick it there. If not ... don't.

if there would only be one or to tables "Sub" then i would out int into the big table
but there are up to 10 "Sub" tables - thus a big tables with many many null values Received on Fri Apr 05 2002 - 03:13:40 CST

Original text of this message

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