Flattening the data (denormalizing)

Hello all,
What are the considerations to take if i have to flatten (denormalize) the data?
Is there any guidelines or documentation available in net?
Any lead on this is highly appreciated.
Thank you,
VenugopalHi Venugopal,

The decision to denomalise and which columns to include / repeat depends on the kind of queries you would run on your data. The aim should be to minimise joins to improve performance.

You might want to also revise the rationale for the normal forms once, to decide your candidates for denormailsation and the type of denormalisation to be applied to each.

Regards.|||Here's another trick (see link) you can try before denormalising along:

http://www.sqlservercentral.com/columnists/chedgate/indexedviews.asp

Also take a look at these articles,

http://dmreview.com/master.cfm?NavID=193&EdID=5251

http://dmreview.com/master.cfm?NavID=55&EdID=5337