Re: To De-Normalize or Normalize ?

Depending upon exactly where your response time is lacking, there are two other possible solutions that immediately come to mind:

• Appropriate additional indexes for frequently hit column(s)
• Precalculated summary tables

Christian Roig wrote:

> How do you get faster response-times from queries ?
>
> Some people argue that you
>
> A)
> have to De-Normalize your database, so that you have fewer joins, which in turn
> results in faster response-times from your queries.
>
> B)
> have to Normalize your database, so that you can have more data in memory, which
> in turn results in faster response-times from your queries.
>
> What is YOUR experience ?
>
> Why and/or When do YOU either De-Normalize or Normalize your database ?
>
> TIA - Christian
>
> *-*-* Disclaimer *-*-*
> The Questions, Answers, Opinions etc. stated in this
> message are my own !

--

Barry
Speaking only for myself, to do otherwise would be presumptuous.