Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Design question : Normalize or Not to normalize ?
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