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

What are the rendering extensions of ssrs?

125


How many null values we can have in a unique key field in sql server?

715


How do I save a stored procedure in sql server?

668


What is star, snowflake and star flake schema? : sql server analysis services, ssas

856


How many columns can we include on clustered index ?

677






How many types of attribute relationships are there? : sql server analysis services, ssas

773


What is TDS(Tabular Data Stream) Gateway?

115


What is a sql join?

748


What do you mean by a dependent functionality in a build?

830


Explain few examples of stored procedure over triggers?

690


What is blocking and how would you troubleshoot it? : sql server database administration

765


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

677


Does sql server use t sql?

724


How to delete existing triggers using "drop trigger"?

764


What were the latest updates to SQL Azure service?

102