Denormalization

Hi friends,

Can you please explain me What is Denormalization?
Are there any advantages?

Can you give some examples in the real time where denormalizing is required?

Thank You

Suroop

Denormalization generally refers to bending the rules of third normal form (3NF) in order to improve performance.

There are many posts that will explain normalization (3NF), but in general, it means

the key, the whole key, and nothing but the key, so help me Codd.



[Edited by dknight on 03-13-2002 at 12:11 PM]

Something interesting on Denormalization:

http://www.firstsql.com/dbdebunk/fp5a.htm