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: Design question : Normalize or Not to normalize ?

Re: Design question : Normalize or Not to normalize ?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 14 Oct 2004 05:38:33 -0700
Message-ID: <73e20c6c.0410140438.2ded77e6@posting.google.com> 





Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097720911.317026_at_yasure>...



> 

> 3,8 million rows in a properly designed and indexed schema is

> insignificant. Only denormalize if there is a compelling reason to

> do so based on actual performance problems.




Absolutely!  Nowadays the number of rows is not as much 
a concern as the design.  Correct normalization to start
with is essential.  DeNormalize only if needed and
in small doses!
Received on Thu Oct 14 2004 - 07:38:33 CDT












Original text of this message













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