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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / praveen

Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / praveen

If the database developer might want a reversal of
normalization to improve performance is called
denormalization.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is #table in sql server?

0 Answers  


How to list all user names in a database?

0 Answers  


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

0 Answers  


Can a rule be bound to any column of any data type?

0 Answers  


What is partition index in sql server?

0 Answers  






Is the log file is a part of file group?

0 Answers  


what is a cursor and what is its use?

2 Answers   L&T,


How to resolve the orphan use problem? : sql server security

0 Answers  


Which are ddl commands?

0 Answers  


How many levels of sp nesting is possible?

0 Answers  


Difference between drill down and drill through report.

0 Answers  


What are the different types of upgrades that can be performed in sql server?

0 Answers  


Categories