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: Tony <andrewst_at_onetel.com>
Date: 18 Oct 2004 15:04:34 -0700
Message-ID: <ed8a00fa.0410181404.25b43f66@posting.google.com>


JEDIDIAH <jedi_at_nomad.mishnet> wrote in message news:<slrncn84cc.b38.jedi_at_nomad.mishnet>...
> So? How do you go about tuning the performance of a query that requires
> a 3-5 way join due to normalization? What about the case where the 5-way
> join would tend to generate full scans on multiple tables where the
> denormalized version would be index range scans?

Add the missing indexes, maybe? Seriously, can you construct an example to illustrate? Because I can't imagine it, really. Received on Mon Oct 18 2004 - 17:04:34 CDT

Original text of this message

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