To De-Normalize or Normalize ?

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