What is de-normalization and when do you do it?

Answer Posted / swapna

As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Unique Key?

596


What is the impact on other user sessions when creating indexes?

544


Can a cursor be updated? If yes, how you can protect which columns are updated?

525


How to use "begin ... End" statement structures in ms sql server?

528


How can you append an identity column to a temporary table?

451






How many databases can we create in a single server?

187


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1223


Explain cursor as data base object?

583


What Is Rdbms?

678


What is the difference between resultset and resultsetmetadata?

523


How do users use Report Builder with SQL Server data sources?

119


Call by value and call by reference in procedure and function, with NOCOPY.

844


What are the advantages of policy management?

587


How to create “dependant” parameter “make, model, year”

89


What structure can you implement for the database to speed up table reads?

715