Re: To De-Normalize or Normalize ?

Both are right. You have to ask for more questions. No general answer.
If the answer was so simple, no need for DBA. Continue, it's a long quest !

.
Christian Roig a écrit dans le message <360a208f.11106841_at_news.tele.dk>...
>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 !
Received on Thu Sep 24 1998 - 00:00:00 CDT