What is de-normalization and when do you do it?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is #table in sql server?
How to list all user names in a database?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Can a rule be bound to any column of any data type?
What is partition index in sql server?
Is the log file is a part of file group?
what is a cursor and what is its use?
How to resolve the orphan use problem? : sql server security
Which are ddl commands?
How many levels of sp nesting is possible?
Difference between drill down and drill through report.
What are the different types of upgrades that can be performed in sql server?